### Database Schema:
CREATE TABLE driver (
	driver_id	INTEGER	NULL	PRIMARY KEY,
	first_name	TEXT	NULL,
	last_name	TEXT	NULL,
	address	TEXT	NULL,
	city	TEXT	NULL,
	state	TEXT	NULL,
	zip_code	INTEGER	NULL,
	phone	TEXT	NULL
);

CREATE TABLE city (
	city_id	INTEGER	NULL	PRIMARY KEY,
	city_name	TEXT	NULL,
	state	TEXT	NULL,
	population	INTEGER	NULL,
	area	REAL	NULL
);

CREATE TABLE shipment (
	ship_id	INTEGER	NULL	PRIMARY KEY,
	cust_id	INTEGER	NULL,
	weight	REAL	NULL,
	truck_id	INTEGER	NULL,
	driver_id	INTEGER	NULL,
	city_id	INTEGER	NULL,
	ship_date	TEXT	NULL,
	foreign key (truck_id) references truck (truck_id),
	foreign key (driver_id) references driver (driver_id),
	foreign key (city_id) references city (city_id),
	foreign key (cust_id) references customer (cust_id)
);

CREATE TABLE truck (
	truck_id	INTEGER	NULL	PRIMARY KEY,
	make	TEXT	NULL,
	model_year	INTEGER	NULL
);

CREATE TABLE customer (
	cust_id	INTEGER	NULL	PRIMARY KEY,
	cust_name	TEXT	NULL,
	annual_revenue	INTEGER	NULL,
	cust_type	TEXT	NULL,
	address	TEXT	NULL,
	city	TEXT	NULL,
	state	TEXT	NULL,
	zip	REAL	NULL,
	phone	TEXT	NULL
);

### User's Query:
Calculate the percentage of the weight of goods being transported by Zachery Hicks to California in year 2016.

### Extra Knowledge:
"California" is the state; in 2016 refers to CAST (ship_date AS DATE) = 2016; percentage = Divide (Sum(weight where first_name = 'Zachery' AND last_name = 'Hicks'), Sum(weight)) * 100
SELECT CAST(SUM(CASE WHEN T2.first_name = 'Zachery' AND T2.last_name = 'Hicks' THEN T1.weight ELSE 0 END) AS REAL) * 100 / SUM(T1.weight) FROM shipment AS T1 INNER JOIN driver AS T2 ON T1.driver_id = T2.driver_id WHERE STRFTIME('%Y', T1.ship_date) = '2016'