- Given the database on this page, select a command from the list below that will select only the readings from the survey table in the most readable form.
a) SELECT * FROM survey;
b) SELECT reading FROM survey
c) SELECT reading FROM survey;
d) SELECT READING FROM SURVEY;
- Given the following fragments, put together a SQL statement that will select the identifier and location from the database. (More than one correct answer may be possible)
SELECT ident, ident, ident,
FROM site;
ident, site
SELECT name, lat, long
FROM visited;