| 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 : |
Lab03: Perform simple query Grading Criteria Demonstrated assignment effectively: 8 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. Calculated.sql: # orderNumber, productCode, quantityOrdered, priceEach, orderLineNumber SELECT *, quantityOrdered * priceEach AS subtotal FROM orderdetails LIMIT 10; -0 Work submitted incorrectly. Your Lab04 folder was misnamed `LAB04`. Points will be deducted for this in the future. -0.8 Work submitted late. -1 Your Student-Lab03-Calculated.png screenshot was not saved in the correct file format. It was a jpg image with a png extension. -1 Your Student-Lab03-Calculated.png screenshot does not show the query as required. I want only the Workbench window. -1 Your screenshot screenshot does not show the entire result as required. The query in the window would not produce the result shown. -4 Instead of calculating quantityOrdered * priceEach as subtotal you instead used the CONCAT function. -1 The SELECT field list does not include all fields from orderdetails. -1 The SELECT field list is not in the correct order. -2 You rounded subtotal off to the dollar, not the cent. The sum is too imprecise. -1 There is no subtotal field in the orderdetails table. -1 The calculated field is not named subtotal. -1 The query should not have an ORDER BY clause. -1 The query does not have the LIMIT clause. You used the Limit dropdown instead. -1 The query does set a LIMIT as required by step 2.3. -1 You have two SELECT statements. This will give you two results. I only want one. -4 Somehow, instead of calculating quantityOrdered * priceEach as subtotal you have a subtotal field in your orderdetails table. I don't know how this field was added to your orderdetails table, but it should not be there. The subtotal should be calculated in the query.