Write and execute a query to display just department details for departments which have employees being paid between 2100 and 2500.
How many departments do you see?
Note: the data is stored in emp_<<your lab username>> table and deptt_<<your lab username>> table in retail_db in MySQL as described earlier.
Taking you to the next exercise in seconds...
Want to create exercises like this yourself? Click here.
Note - Having trouble with the assessment engine? Follow the steps listed here
Loading comments...