Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PIease answer questi0n 9 only. lent Students are about to graduating and trying to submit job applications to different companies like Google, Facebook, Apple, and
PIease answer questi0n 9 only.
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/ Previous Page Next Page Page 9 of 9 Question 9 (9 points) Write SQL statements to query the name and city of the companies which receive the most applications. (You will not get any point if your statement is not getting the correct result) 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/ Previous Page Next Page Page 9 of 9 Question 9 (9 points) Write SQL statements to query the name and city of the companies which receive the most applications. (You will not get any point if your statement is not getting the correct result)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