SQL Oracle I’ve included screen shots of the tables , i need the queries

SQL Oracle I’ve included screen shots of the tables , i need the queries

Get to know the grocery database, its tables, and their contents. Use your common sense on these. Show the SQL query and the output AND the answer to the question. DO NOT provide IDs in the final answer unless directed; all answers should be meaningful. Use JOIN for multiple table query.

1. Which stores have ordered ice cream?
2. Which salaried employees are over 20 and work at Manhattan 5?
3. What are the names and telephone numbers of the contacts at the vendors that sell ice cream?

4. Has any product yet to arrive?

5. Who works at Manhattan 3?
6. Which employees have both daughter and son?

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.

Discount Code: CIPD30

Click ORDER NOW..