Reference no: EM131335114

Question 1:

Use the tables below to answer the following questions:

customerid
customerid	firstname	lastname	city	state
10101	John	Gray	Lynden	Washington
10298	Leroy	Brown	Pinetop	Arizona
10299	Elroy	Keller	Snoqualmie	Washington
10315	Lisa	Jones	Oshkosh	Wisconsin
10325	Ginger	Schultz	Pocatello	Idaho

items_ordered
customerid	order_date	item	quantity	price
10330	30-Jun-99	pogo stick	1	28
10101	30-Jun-99	Raft	1	58
10298	1-Jul-99	Skateboard	1	33
10101	1-Jul-99	Life Vest	4	125
10299	6-Jul-99	Parachute	1	1250

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:

As a database administrator, grant and revoke the following privileges to the next users:

1. user1 allowed to select and insert on table (employee, manages).

2. user2 are not allowed anymore to update on table (company).

Question 3:

What is JavaScript?