An astrophysicist wants to retrieve a list of all exoplanets from the database that were discovered using the 'Transit' method.
| PlanetID | Name | Method | YearDiscovered |
|---|---|---|---|
| EP-402 | Kepler-186f | Transit | 2014 |
| EP-403 | Proxima b | Radial Velocity | 2016 |
| EP-404 | Osiris | Transit | 1999 |
| ObsID | PlanetID | ObservatoryID |
|---|---|---|
| 9001 | EP-402 | 77 |
| 9002 | EP-403 | 78 |
| ObservatoryID | FacilityName | Location |
|---|---|---|
| 77 | Kepler Space Telescope | Earth Orbit |
| 78 | La Silla Observatory | Chile |
The following SQL query is run to produce the list:
A Name, Method, YearDiscovered FROM Exoplanet WHERE B
Some parts of the SQL query have been replaced by labels A and B.
State the SQL statements or clauses that should have been written in place of the labels A and B.
Practise AQA GCSE Computer Science Structured query language (SQL) with exam-style questions for GCSE Computer Science. 25 questions, matched to the AQA GCSE Computer Science (8525) specification and written in Paper 1 and Paper 2 style. Every question includes a full worked solution and mark scheme, so you can see where marks are awarded rather than just whether you got the answer right.