| 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 5 - Perform subqueries
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.
I reserve the right not to apply the deduction points at my absolute discretion.
-1 Work submitted incorrectly.
Your folder was misnamed `LAB05` instead of `Lab05`.
-8 You zip file was empty.
=e
-0.8 Work submitted late.
# ReportsToGerard.sql:
SELECT employeeNumber
, lastName
, firstName
FROM `employees`
WHERE reportsTo = ( SELECT employeeNumber
FROM `employees`
WHERE lastName = 'Bondur'
AND firstName ='Gerard'
)
;
-4 The .sql file you sent me does not contain the query.
-4 Step 2.1; You do not want the employeeNumber field in your primary query WHERE clause.
You want who the employee reports to (reportsTo).
=e
-2 Step 2.1; You did not list every employee that reports to Gerard Bondur as required.
Instead you listed employees with specific first names.
-3 Step 2.1; Your subquery is not specific enough.
You are getting results for more than Gerard Bondur.
-3 Step 2.1; Your WHERE phrase does not have a condition.
You are getting results for more than Gerard Bondur.
You need to test reportsTo against your subquery.
-2 Step 2.1; Your subquery is not specific enough.
There are two employees with a last name of Bondur, Loui just happens to have no one reporting to him.
-3 Step 2.2; You may NOT use Gerard Bondur's employeeNumber (1102) directly in the query.
You must use a subquery to obtain it.
-3 Step 2.2; You may NOT use Gerard Bondur's employeeNumber (1102) directly in the subquery.
I suggest using what you know, the employee's first and last name to obtain the employeeNumber.
-1 Steps 2.6; You do not show both the query and the result in the screenshot.
The screenshot is not of the MySQL Workbench window, just part of it.
-1 Step 2.7; The screenshot is not of the MySQL Workbench window, just part of it.
-1 Step 2.7; The screenshot you turned in is not the result of this query.
Did you turn in the screenshot for lab 5.5 instead.
# RepresentedByFoonYue.sql
SELECT customerNumber
, customerName
, contactFirstName
, contactLastName
, phone
FROM `customers`
WHERE salesRepEmployeeNumber = ( SELECT employeeNumber
FROM `employees`
WHERE lastName = 'Tseng'
AND firstName ='Foon Yue'
)
ORDER BY customerName
;
# RepresentedByFoonYue.sql:
-1 The SELECT field list is not in the correct order.
-1 You do not want the customerNumber field in your primary query WHERE clause. You want who the sales rep employee number (salesRepEmployeeNumber).
-1 Step 3.2; You did not order the result by customerName.
-3 See step 3.3. You may NOT use Foon Yue Tseng's employeeNumber (1286) directly in the query.
You must use a subquery to obtain it.
Try selecting his employeeNumber using his name in a subquery.
-3 See step 3.3. You may NOT use Foon Yue Tseng's employeeNumber (1286) directly in the subquery.
Try selecting his employeeNumber using his name in a subquery.
ReportsToGerard.sql:
-0 Your subquery is really not specific enough. It returns two employeeNumbers.
If Loui had also supervised employees you would get them as well.
RepresentedByFoonYue.sql
-0 You could have the same problem here if there were two employees with the last name of Tseng.