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.
25 exam-style questions on AQA GCSE Computer Science Structured query language (SQL). Each one has a worked solution and a mark scheme showing where the marks go.