SQL Test 1 Section 1 - Coding (25 points): Create a database "SalesLand" for the SalesLand company with the following tables: C 1. Product table id name dept price 1 Desk 1 $150 2 Chair $80 3 Bed $320 4 Chest NW N S $220 Shelf $180 2. Salesperson table Id Name Dept Salary 1 Nancy 1 $240 Bill 2 $200 A W N Steve 3 $300 Kate 1 $320 3. Sales table product sold_by 1 3 2 2 3 3 4 3 2 3 3 4 1 4 N W W 1. Write a query to display the total amount sold by Steve 2. Write a query to display the total amount of Bed sales 3. Write a query to show the total amount collected by the entire store 4. Which product generated the highest sales revenue 5. Which person sold the most in terms of product counts