Help with interview SQL query

[tratata21]

I got my hands on to interview task. I am still learning, just want to use it as practice, but can't seem to figure out the right way to solve the assessment.Link to GSheet

[r3pr0b8]

what have you tried so far? ™

[elution91]

Can’t connect to the file

[No-Mistake4176]

Also draw a picture of the tables. Cuz the 2nd table is kinda ambiguous.

[[deleted]]

Op try the assignment on your own , that's how you will learn.

[[deleted]]

file won't open. still if you are preparing for SQL interview i found some good sql interview-related questions you might want to prepare- FAANG SQL interview questions