P744 THE CH07 LARGECO ERD cust Code LGSAARY HISTORY FREE Emp

P7.44 THE CH07 LARGECO ERD cust Code LGSAARY HISTORY FREE Emp Phone LGDEPARTMENT Emp Num 45. display the SKU (stock keeping unit), description, type, base, cat Write a query to of water and a PROD egory and price for all products that have a PROD BASE CATEGORY of sealer (Figure P7.45). FIGURE P7.45 WATER-BASED SEALERS PR00 CATEGORY PROD rite a query display the first name, last name, and email address of employees hired l, 2003, to 31, Sort output last from Ja 46, then by first name (Figure P7.46). a query to display the first name, last name, phone number, title, and 47. W rite ment number of employees who work in department 300 or have the title \"CLERK I by last name and then by first name (Figure P7.47). Sort the output

Solution

44. Select Distinct Dept_Name from LGDEPARTMENT ;

45. Select * from Water_Based_Sealers Where PROD_BASE=\'water\' AND PROD_CATEGORY=\'sealer\';

46. Select * from EMPLOYEES_HIRED Order by EMP_LNAME;

Select * from EMPLOYEES_HIRED Order by EMP_FNAME;

47. Select * from CLERKS_AND_EMPLOYEES Where DEPT_NUM=\'300\' OR EMP_TITLE =\'CLERK I\' Order by EMP_LNAME;

Select * from CLERKS_AND_EMPLOYEES Where DEPT_NUM=\'300\' OR EMP_TITLE =\'CLERK I\' Order by EMP_FNAME;