Reference no: EM131163799

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.