In SQL, the SELECT statement is used to retrieve data from a database. This is identified by inserting The asterisk (*) . When you use * in a SELECT statement, it instructs the database to retrieve data from all columns in the specified table, in this case we are selecting all fields from the RANK_ rt table.
If you don't require all columns from a specific table then you can specify which columns you need by writing them. In this case we are bringing back only the "t1.fastestlapspeed" column from the RESULTS table. If you want to being back more than 1 column from a table, remember to add a comer ' , ' before specified column names.
