Need sql. Need to be joins I believe

1. Using the Football database, create a query that will show the team name and gamedate for those teams that have not won a game. Remove from your output the team named No Winner and whe the game date has a value. Your answer should look like: teamName gameDate Red Tigers NULL 2. Using the Tutor database, create a query that will show the first and last name of those studentsw have not attenued cuton session date is Also include the session date. Only include those records where the utput should look like: StudentFirstName StudentLastName SessionDateKey Ly Ron Juan Patty Min Bradbury Carlos Taylor NULL NULL NULL NULL 1. Using the Football database, create a query that will show the team name and gamedate for those teams that have not won a game. Remove from your output the team named No Winner and whe the game date has a value. Your answer should look like: teamName gameDate Red Tigers NULL 2. Using the Tutor database, create a query that will show the first and last name of those studentsw have not attenued cuton session date is Also include the session date. Only include those records where the utput should look like: StudentFirstName StudentLastName SessionDateKey Ly Ron Juan Patty Min Bradbury Carlos Taylor NULL NULL NULL NULL