3. MENU RECOMMENDATION (Part 1: Meal Type)

First create 4 records in the MC_90_DAYS_MEAL_TYPE table completing the INSERT statements

below. You MUST assign a specific PK value to each record. However, all your queries MUST NOT

assume those IDs in any circumstances.

I will test your queries in my own data, and you will NOT know which MEAL_TYPE_ID I used to

create each record, i.e., all filters and condition in queries MUST use the MEAL_TYPE_NAME

column.

INSERT INTO MC_90_DAYS_MEAL_TYPE (MEAL_TYPE_ID, MEAL_TYPE_NAME)

VALUES (

'Breakfast');

I

INSERT INTO

MC_90_DAYS_MEAL_TYPE

(MEAL_TYPE_ID, MEAL_TYPE_NAME)

VALUES (

'Lunch ');

INSERT INTO MC_90_DAYS_MEAL_TYPE (MEAL_TYPE_ID, MEAL_TYPE_NAME)

VALUES (

'Afternoon snack');

INSERT INTO MC_90_DAYS_MEAL_TYPE (MEAL_TYPE_ID, MEAL_TYPE_NAME)

VALUES (

'Dinner');

COMMIT;

I

I

I