Answered step by step
Verified Expert Solution
Question
1 Approved Answer
lent Students are about to graduating and trying to submit job applications to different companies like Google, Facebook, Apple, and Amazon, etc... There is a
lent Students are about to graduating and trying to submit job applications to different companies like Google, Facebook, Apple, and Amazon, etc... There is a database to keep track of a group of students and their job applications to different companies. There are 3 tables in the database: 1. Table: students (with 2 columns: id, name). Example: id name 11 Wilson 2 Jonathan 3 Erica 4 Tom 5 Amy 2. Table: companies (with 3 columns: id, name, city). Example: id name city 1 Google | Menlo Park 2 | Facebook | Menlo Park 3 | Apple Cupertino 4 Amazon Seattle 3. Table: records (with 4 columns: id, apply_date, student_id, company_id). Example: id apply_date student_id company_id 1|11/02/2020314 2/12/22/2020 415 31 01/08/2021 11 41 02/03/2021|1|4 Question 7 (8 points) Write a SQL statement to query all the companies in the companies table locate at "Menlo Park". (You will not get any point if your statement is not getting the correct result) A/
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started