This question related to MYSQL Technology
Thank you
Question 1:2 marks)
Use the tables below to answer the following questions: customers customeridirstnamelastname city 10101 state Dohn Gray Lynden 0298 Washington Leroy Brown Pinetop Arizona 10299 Elroy Keller Snoqualmie 10315 Washington Lisa Oshkoch 10325 Wisconsin Ginger Schultz Pocatello idaho
items_ordered customeridorder date item 10330 30-un-1999Pogo stick 10101 30-Jun-1999 lRan 10298 01-Jul-1999 Skateboard 10101 01-ul-1999 Life Vest 10299 06-ul-1999 Parachute
quontityprice 1 28.00 58.00 1 33.00 4 125.00 11 1250.00
1.Find the customerid of customers in the customers table that have 10101 as customerid
2.Find the highest price of an item in items ordered table.
Question 2:(2 marks) As a database administrator,grant and revoke the following privileges to the next users: 1.userl allowed to select and insert on table employee,manages
2.user2 are not allowed anymore to update on table (company)