Part 1

• Left Join
• Right Join
• Similarities of 2 SQL statements
• Union
• Inner Join

Part 2

• DQLab Mart Product
• Thumb drive at DQLab Mart
• Customer with degree
• Sorting customer name
• Sorting customer names without degree
• Longest customer name
• Longest customer name with degree
• Largest quantity of sold product
• The customer with the highest transaction value
• Customers who have never transact
• Shopping transactions with more than 1 shopping list