Goal: Use the MIN function.
Using the class example database (SQLFUN):
Find the price of the least expensive food in the L_foods table. Find all the foods with that minimum price.
- The supplier_id is CFF.
- The product_code is SA.
Goal: Find rows that are not matched. (They are dropped from an inner join.)
Using the class example database (SQLFUN):
- Are there any employees who are not attending any of the lunches? If so, who are they?
- List the Employee ID, first name, and last name of these employees.
- Sort them on the employee_id.