The youth club needs to produce a report listing the members who have been given the Leader award. The report must include both names of each member and the date the award was presented. The results must be in order of the date the awards were presented, starting with the earliest.
Write an SQL query that could be used to find this information.

To construct this SQL query, we need to combine data from two tables and then filter and sort it. SELECT Member.FirstName, Member.LastName, Award.DatePresented FROM Member INNER JOIN Award ON Member.MemberID = Award.MemberID WHERE Award.AwardName = 'Leader' ORDER BY Award.DatePresented ASC; **Explanation of each clause:** - `SELECT Member.FirstName, Member.LastName, Award.DatePresented`: This specifies the columns we want to see in our final report. We need the first and last names from the `Member` table and the presentation date from the `Award` table. - `FROM Member`: This indicates that we are starting our query with the `Member` table. - `INNER JOIN Award ON Member.MemberID = Award.MemberID`: This is the crucial step that links the two tables. It tells the database to match rows from the `Member` table with rows from the `Award` table where the `MemberID` is the same in both. - `WHERE Award.AwardName = 'Leader'`: This is a filter. It instructs the database to only include the records where the name of the award is 'Leader'. - `ORDER BY Award.DatePresented ASC`: This sorts the final result set. It orders the rows based on the `DatePresented` column in ascending (`ASC`) order, from the earliest date to the latest.