oorder_details arde_c lie (11) (1)-4INT(i) arde findia(is) aitems tem _dwr(si) Ble YAOHAR(S) sort Yarohas\{to\} Tintrice Dermatgid 1. How many customers are there from the state of Callfornia? 2. Identify the most expensive item by listing allitems sorted by price with the largest price on top. 3. List all customers with the letter Y in somewhere in their first or last name. 4. Modify the query from number 3 to show just the sum of the customer id and a count of the first name for all customers with the letter Y in their first or last name. fyes, I mean sum of the customer id - It is the only numeric field in that table.m) 5. Ust all products where the yolt_price is larger tif? the average unit. pilce. Hint, you may have to run 2 querles to find the answer.u. Part 2 - Multh-Table Selects 6. Ust the customer first and last name, and the order date for all orders that have not yet shipped. (ship date is empty) 7. What product is our best seller (has sold the most items?) Show the item id and the title along whth the number of order detalls and total quantity sold for each ltem. (units, not dollary) 8. Modliy the query in number 7 so that it also shows the sales totals by year and then by item. Hint: you can use the year function to break the year out of a date - year(gusdatel 9. Show a tist of all products that were shipped to customers in Calffornla during 2010. The llst should show the vear, the ltem tille and the total quantity that was ordered 10. Narrow the llst from number 9 to show only ltems where more than 1 unit was shlpped to Gillomis, and then sort the list from blesest to smallest using the total quantity shipped