Problem 1
Write SQL queries
1. Write a SQL query that joins Customer and Store table in the Kudler database and uses BETWEEN to restrict record selection
(use Store Name to restrict the data).
2. Write a SQL query that Customer and Store table in the Kudler database and uses LIKE to restrict record selection (use Store
Phone Number to restrict data).
3. Group Customers by Store Name: Select the Customer's last name and group them by Store Name.
4. Choose a Customer from the Customer table, delete this Customer.
5. Calculate the maximum labor cost for all item types from the Item Table.
Problem 2
In addition create your own SQL query from the database
· GROUP statement
· UNION statement
· JOIN statement
· INSERT statement
· DELETE/DROP statement