Question

Display the `insid` and `insname` for all inspectors that have any inspections scheduled after 1-Apr-2020. Do not display the same information more than once.

a) SELECT insid, insname FROM inspectors WHERE inspection_date > '2020-04-01';
b) SHOW insid, insname FROM inspectors WHERE inspection_date AFTER '2020-04-01';
c) PRINT insid, insname FROM inspectors WHERE inspection_date > '2020-04-01';
d) VIEW insid, insname FROM inspectors WHERE inspection_date AFTER '2020-04-01';

Answer 1

The correct query to display the insid and insname for all inspectors that have any inspections scheduled after 1-Apr-2020 is option a).

The correct query to display the insid and insname for all inspectors that have any inspections scheduled after 1-Apr-2020 would be option a):

SELECT insid, insname FROM inspectors WHERE inspection_date > '2020-04-01';

This query selects the columns insid and insname from the table inspectors where the inspection_date is greater than '2020-04-01'.