| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/Classes/CST1600/Labs/ |
Upload File : |
Lab 2.5 - Another simple query
Grading Criteria
Demonstrated assignment effectively: 7 points.
There are some things I expect. If they are incorrect you will lose the following:
Work submitted incorrectly: -1 pt. This covers errors such as incorrect files names, incorrect file formats, poor formatting, etc.
Second and subsequent submission of work for grading: -1 pt.
Work submitted late: -1 pt per week.
-0 Work submitted incorrectly.
Your Lab04.5 folder was misnamed `LAB04.5`.
Points will be deducted for this in the future.
-0.7 Work submitted late.
-1 Work submitted incorrectly.
You are missing the ConnorBratsch_Lab04.5_Decending.png screenshot.
=e
Descending.sql:
SELECT customerNumber, customerName, contactFirstName, contactLastName
FROM `customers`
ORDER BY contactLastName DESC, contactFirstName
LIMIT 10;
-1 Your Student-Lab03-Decending.png screenshot does not show the query as required.
I want the Workbench window.
-1 The SELECT field list is not in the correct order.
-2 The ORDER BY clause is not as required by step 2.2.
-3 The ORDER BY clause required by step 2.2 is missing.
-1 The Descending query does not have the LIMIT clause.
You used the Limit dropdown filter instead.
-4 You sql does not get the desired result.
You have the LIMIT and ; ending the statement before the ORDER BY.
-4 You sql does not get the desired result.
You should return only the customerNumber, customerName, contactFirstName, and contactLastName.
=e