Database Systems

1) Create an SQL view named RichEmployeeComputers to display the COMPUTER make, model and list price for computers that are owned by employees who earn at least 500,000, using these tables

2) Write an SQL statement to display the names of the MANUFACTUREs who do not have any models in the COMPUTER table using these tables,

MANUFACTURER Name Dell IBM Gatewa Apple COMPUTER Model SerialNumber|Make 9870 8590 7840 4870 EmpNo 123 456 123 789 State TX ListPrice 649.99 Austin White Plains NY Sioux Cit Cupertino Gateway Apple Dell Dell DX4850 IA CA eMacBook Air Alienware XPS 899.00 799.99 EMPLOYEE EmploveelD 123 456 789 EmpName Salarv Uc Charlie Linus Pat 500,000 600,000 300,000 200,000 HireDate 01/02/1993 02/03/1992 01/25/1995 11/23/2003