Use the online database provided by Live SQL in Find option.

To take an overview about any schema select Find option in live sql, then to access a table in your queries from other schema write shcema name before table name schema_abbreviation.table_name

For each query screenshot the SQL code and the result table.

Arrange everything in 1 file by the query number.

Upload your work to Blackboard as a PDF file.

A) Work on (customers), (orders), and (stores) tables from co schema as needed:

1. List customer ids, customers full name and order ids, using left join. 2. List stores names of the refunded orders, using subquery.

3. List full information of the orders of the customer name 'Victor Morris', using subquery.