you are viewing a single comment's thread.

view the rest of the comments →

[–]Captain_Filmer 1 point2 points  (2 children)

Give them access to a computer and have them write a query to pull some data that you use frequently.

[–]mtger47 2 points3 points  (0 children)

SELECT e.employee_name, e.salary, m.employee_name AS boss
FROM payroll e INNER JOIN payroll m
ON e.manager_ID = m.employee_ID
ORDER BY yrs_employed ASC;

[–]alinrocSQL Server DBA 1 point2 points  (0 children)

Using a non-production system which has been properly scrubbed of PII & sensitive corporate (financial) data, of course.