Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help me to do all the questions 4. Construct the SQL statement to display the customer(s) who have TWO OR FEWER computers. Rename the
please help me to do all the questions
4. Construct the SQL statement to display the customer(s) who have TWO OR FEWER computers. Rename the second column as NAME and the third column as TOTAL COMPUTERS. Sort DESCENDING by the CUSTOMERID. Your SQL result must be displayed as follows: CUSTOMERID NAME TOTAL COMPUTERS CUSTS Lai Teng 1 CUST4 Sarimah Jailani 1 1 CUST1 Sulaiman Ahmad (20 marks) 5. Construct the SQL statement to find those repair jobs performed by Yee Yee and Sayuti Hamid. Your SQL result must be displayed as follows: JOBNUM DATE RECEIVED LABOUR TOTAL COST COST COMMENTS DATE ENDED FIRST LAST NAME NAME J1 06/01/2015 150 300 COMPLETE Yee 06/04/2015 Yee 10/19/2015 Sayuti J2 10/15/2015 100 250 COMPLETE Hamid (18 marks)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started