Question: please help me to do all the questions QUERIES 1. Construct the SQL statement to get the customer ID, full name, and address of the

please help me to do all the questions

please help me to do all the questions QUERIES 1. Construct the

QUERIES 1. Construct the SQL statement to get the customer ID, full name, and address of the customer who lives at Jalan Durian Sort ASCENDING by the "FULL NAME". Your SQL result must be displayed as follows: CUSTOMERID FULL NAME ADDRESS CUSTS Lai Teng No 10 Jalan Durian, Taman Berjaya, Ayer Keroh, 75451 Melaka No 6 Jalan Durian, Taman Sentosa, Shah Alam, 70000 Selangor CUST4 Sarimah Jailani (10 marks) 2. Construct the SQL statement to display the total computers. Rename the column as TOTAL COMPUTERS. Your SQL result must be displayed as follows: TOTAL COMPUTERS (8 marks) 3. Construct the SQL statement to display the total computers of each customer. Rename the second column as TOTAL COMPUTERS. Sort DESCENDING by the CUSTOMERID. Your SQL result must be displayed as follows: CUSTOMERID TOTAL COMPUTERS 1 CUSTS CUST4 CUST3 1 3 CUST1 1 (14 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

please help me for this assignment! it's too difficult to pass it... ASSESSMENT TASK Unit of competency: Student's ID: Assessor's name: SITXFIN501 Prepare and monitor budgets 38133 Chiao Hsin Pan...

Mr. Om was very pleased with the work you did for him last week and wants you to retrieve a few more reports for him. He has also recommended you to work for his friend, Mr. Bok who owns a small...

This is the bookstore.sql: DROP TABLE CUSTOMERS CASCADE CONSTRAINTS; DROP TABLE ORDERS CASCADE CONSTRAINTS; DROP TABLE PUBLISHER CASCADE CONSTRAINTS; DROP TABLE AUTHOR CASCADE CONSTRAINTS; DROP TABLE...

Design a database for a simple job tracking system and complete the specified SQL statements to update, delete, and query the database. The final solution should be submitted as a single Script file...

1. Database Design 1.1. Design and create a database in third normal form based on the following requirements: Each Job is for a specific customer and there can be more than one job per customer. The...

Project Steps: 1. Database Design 1.1. Design and create a database in third normal form based on the following requirements: Each Job is for a specific customer and there can be more than one job...

Can someone please help me with this? Create a Microsoft Word document containing your SQL statements for each of the following reports and upload your document to UNM Learn. We want a report that...

Scenario: You work for a DVD rental company. Your manager has asked you to pull some data on the company, its inventory, and customers. You will complete this by developing and running SQL queries....

Your assignment is to write and execute the SQL queries that will produce the data ( record sets ) requested below using the Pine Valley Furniture database in Microsoft Access and Teradata SQL...

Contact the human resources manager of a local business. Ask if he or she would take a few minutes to discuss some issues about rsums with you. Structure your discussion around the following...

How to calculate the current ratio and working Capital? If the current ratio decreases or increases what is the major causes of change? How do you know if your working capital is sufficient? Cash...

A market order is a request to buy or sell a stock at the current market value. True or False 0 0 : 0 7 : 5 9

Q1. Pass jounal enteries for the following transactions Sep 02 Pallares for August 1,500 Sep 06 Cash received from Saleem Ls 1,300 Sep of Purchased as for cash Rs.700 Sep 07 Cushles for the first...

=+j Explain IHRMs role in global HR research.

=+j Describe an effective crisis management program.

=+3 If you were the local HR manager, how would you counsel Richard (or Mr. Somsak)?