Database

Question 1 (100 points]: Write SQL Statements wali SALESMAND NAME CITY COASSION NUMER(S) WHOHAR CHAR(15) DECIMALIS customer CUSTOMER O NUMERIC (0) CUST SAUE VANDHAR 30 CITY MARCHA 15 GRADE NUMERICO BALESMANO NUMERICS orders PORNO NUMERICS PURDLAMT DECIMALI) ORD_DATE DATE CUSTOMERUD NUMERC(8) SALEMANIO NUMERIC Write the SQL query to: 1. Write a SQL query to find the salespeople who lives in the City of Paris'. Return salesperson's name, city. 2. Write a SQL query to find those customers whose grade is 200. Return customer_id, cust_name, city, grade, salesman_id. 3. Write a SQL query to find the orders, which are delivered by a salesperson of ID. 5001. Return ord_no, ord_date, purch_amt. 4. Write a SQL query to find the orders, which are delivered by the salesperson John THOMAS". Return ord_no, ord_date, purch_amt. 5. Write a SQL query to find the orders, which are delivered by the salesperson John THOMAS" to the customer Sarah DUKORT". Return ord_no, ord_date, purch_amt