Im completely new to SQL and using the MySQL Client (MariaDB 10.3). Ive made it to the last question but not sure how to code it. Im also attaching a picture of all the info Ive already have.

Help Tell me what you want to do 1 Normal 1 No Spac... Heading 1 Heading 2 TitleSubtitle Styles Paragraph Run a SELECT statement that joins both tables created in the first exercise. Use the JOIN clause to do this (the JOIN clause was covered in this chapter, so look back at the example if you don't remember how to use it). Join the tables on the common column named relation id this will go in the WHERE clause. To help you with this, here's how the clauses for the tables should look: FROM contacts JOIN relation types WHERE contacts.relation id relation types.relation id Select the columns name and phone mobile, but only for contacts who are marked as a Friend-you'll have to add this to the WHERE with AND. Try doing this based on the value of relation id and then again based on the value of the relationship column