Consider the following schema. where the primary keys are given. Give an expression in SQL for each of the queries. Person ( FirstName:String, LastName:String, Age, Email: varchar) FacebookUser ( FbUserID: Integer, FbUserName:String, Email:varchar, Num_of_friend: integer, Num_of_pic: integer) WhatsAppUser (WhatsAppUserID: Integer, FBUserID: Integer, Cell_num: varchar, WhatsAppUserName:String , No_Of_Groups: Integer) Now, Give an expression in SQL for each of the queries. a) Find the Facebook user who shares the least number of pictures. b) Find the WhatsApp users who are GrameenPhone users (GrameenPhone numbers start with 017.... Or 013....) c) Show the details of your own Facebook account searching by your valid DIU Email. d) List the full names of Facebook users having gmail addresses in dictionary order based upon their names. e) Show all the details of those Facebook users whose number of friends is more than or equal to 500 but less than or equal to1000.

Consider the following schema. where the primary keys are given. Give an expression in SQL for each of the queries. Person ( FirstName:String, LastName:String, Age, Email: varchar) FacebookUser ( FbUserID: Integer, FbUserName:String, Email:varchar, Num_of_friend: integer, Num_of_pic: integer) WhatsAppUser (WhatsAppUserID: Integer, FBUserID: Integer, Cell_num: varchar, WhatsAppUserName:String , No_Of_Groups: Integer) Now, Give an expression in SQL for each of the queries. a) Find the Facebook user who shares the least number of pictures. b) Find the WhatsApp users who are GrameenPhone users (GrameenPhone numbers start with 017.... Or 013....) c) Show the details of your own Facebook account searching by your valid DIU Email. d) List the full names of Facebook users having gmail addresses in dictionary order based upon their names. e) Show all the details of those Facebook users whose number of friends is more than or equal to 500 but less than or equal to1000.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter12: Subqueries And Merge Statements

Section: Chapter Questions

Problem 19MC

See similar textbooks

Similar questions

Question 2: Consider the following relations: Student(snum: integer, sname: string, major: string, level: string, age: integer) Class(name: string, meets at: string, room: string, fid: integer) Enrolled(snum: integer, cname: string) Faculty(fid: integer, fname: string, deptid: integer) Write the following queries in SQL. No duplicates should be printed in any of the answers. Find the names of all Juniors (level = JR) who are enrolled in a class taught by Teach. Find the age of the oldest student who is either a History major or enrolled in a course taught by I. Teach. Find the names of all classes that either meet in room R128 or have five or more students enrolled. Find the names of all students who are enrolled in two classes that meet at the same time. Find the names of faculty members who teach in every room in which some class is taught.
In Sql These are some database from a set of tables insert into AccountHolder(AccountID, CustomerID, AccountType)values (55003, 115, 'Savings'),(44001, 101, 'Chequing'),(55006, 109, 'Savings'),(44002, 102, 'Chequing'),(44003, 113, 'Chequing'),(55007, 108, 'Savings'),(44004, 103, 'Chequing'),(44005, 110, 'Chequing'),(55005, 112, 'Savings'),(44006, 114, 'Chequing'),(55001, 111, 'Savings'),(44007, 107, 'Chequing'),(44008, 104, 'Chequing'),(55004, 106, 'Savings'),(44009, 105, 'Chequing'),(44010, 113, 'Chequing'),(55002, 107, 'Savings'),(44011, 110, 'Chequing'),(44012, 104, 'Chequing') select * from AccountHolder insert into Branch(LocationID, BranchName, Address, Type, DepositSum, LoanSum)values (1, 'Boulevard Branch', '3268 Wade Boulevard', 'Rural', 171848.88, 37681.72),(2, 'Avenue Branch', '4814 Dare Avenue', 'Rural', 232707.42, 68324.56),(3, 'Street Branch', '208 Ferry Street', 'Commercial', 375010.75, 44665.08),(4, 'Road Branch', '468 Zulauf Road', 'Commercial', 496001.41,…
Question 2: Consider the following relations: Student(snum: integer, sname: string, major: string, level: string, age: integer) Class(name: string, meets at: string, room: string, fid: integer) Enrolled(snum: integer, cname: string) Faculty(fid: integer, fname: string, deptid: integer) Write the following queries in SQL. No duplicates should be printed in any of the answers. Find the names of all Juniors (level = JR) who are enrolled in a class taught by Teach. Find the age of the oldest student who is either a History major or enrolled in a course taught by I. Teach. Find the names of all classes that either meet in room R128 or have five or more students enrolled. Find the names of all students who are enrolled in two classes that meet at the same time. Find the names of faculty members who teach in every room in which some class is taught. I need last 2 subparts answer
Write SQL retrieval commands for each of the following queries:a. Display the course ID and course name for all courses with an ISM prefix.b. Display all courses for which Professor Berndt has been qualified.c. Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212.
Answer the given question with a proper explanation and step-by-step solution. I wrote a spark SQL query that returns the top 100 users, however, I need to show name rather than user_id. What am I missing? My code is shown below: def users_top_100_tip_count():return spark.sql("""\SELECT tip.user_id, count(*) as tip_countFROM tipLEFT JOIN userON tip.user_id = user.user_idGROUP BY tip.user_idORDER BY tip_count DESC, user_id ASC LIMIT 100""") example of my expected output: +--------+---------+ | name|tip_count| +--------+---------+ | Weifong| 167| | Alice| 42| | Bob| 42| | Jamal| 3| +--------+---------+
Please answer the following in SQL: Find all pairs of customers who have purchased the exact same combination of cookie flavors. For example, customers with ID 1 and 10 have each purchased at least one Marzipan cookie and neither customer has purchased any other flavor of cookie. Report each pair of customers just once, sort by the numerically lower customer ID. The MySQL-specific GROUP_CONCAT and JSON_ARRAYAGG functions are not permitted. customers dataset CId: unique identifier of the customerLastName: last name of the customerFirstName: first name of the customer goods dataset GId: unique identifier of the baked goodFlavor: flavor/type of the good (e.g., "chocolate", "lemon") Food: category of the good (e.g., "cake", "tart")Price: price (in dollars) items dataset Receipt : receipt number Ordinal : position of the purchased item on the receipts. (i.e., first purchased item, second purchased item, etc...)Item : identifier of the item purchased (see…
Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table. If an employee does not belong to a department, then their department number should show as “N/A” and their department city should show up as “No City info Found”. MAKE SURE you have all the employees displayed including the employees who do not have a department.
Consider the following SQL query that seeks to find a list of titles of all coursestaught in Spring 2017 along with the name of the instructor.select name, titlefrom instructor natural join teaches natural join section natural join coursewhere semester = 'Spring' and year = 2017What is wrong with this query?
Consider the following schema:instructor(ID, name, dept_name, salary)What is the correct SQL statement to perform a query to find the names of all instructors excluding duplicates?(a) select name from instructor;(b) select unique name from instructor;(c) select name from instructor no duplicates;(d) select distinct name from instructor;
Q1) Consider the employees database , where the primary keys are underlined. Give an expression in SQL for each of the following queries. Employee(ID. name, age, address, salary, departmet, position,ministry_name) Ministry(ministry_name, address,No_of _employee, No_of_dept., category) 1- Find all employees who live in baghdad and work in ministery of foreign affairs And older than all the employees who work in the consuls department. 2- Find the name of employees who work as a counselor in ministries that have more than 5 departments . 3- Insert a new employee (o the database.
Write a SQL query that retrieves the names and email addresses of all students who are enrolled in at least one course in the "Computer Science" department and have a graduation year of 2022 or later. Include the course name and instructor name for each enrollment in the output. Schemas of the tables are below. "students" table: student_id: unique identifier for the student name: name of the student email: email address of the student major: field of study for the student graduation_year: expected year of graduation for the student "courses" table: course_id: unique identifier for the course course_name: name of the course instructor_name: name of the instructor teaching the course. department: department offering the course. course_description: description of the course "enrollments" table: enrollment_id: unique identifier for the enrollment student_id: identifier for the student enrolled in the course. course_id: identifier for the course the student is enrolled in…
Write a SQL query that retrieves the names and email addresses of all students who are enrolled in at least one course in the "Computer Science" department and have a graduation year of 2022 or later. Include the course name and instructor name for each enrollment in the output. Schemas of the tables are below. "students" table: student_id: unique identifier for the student name: name of the student email: email address of the student major: field of study for the student graduation_year: expected year of graduation for the student "courses" table: course_id: unique identifier for the course course_name: name of the course instructor_name: name of the instructor teaching the course. department: department offering the course. course_description: description of the course "enrollments" table: enrollment_id: unique identifier for the enrollment student_id: identifier for the student enrolled in the course. course_id: identifier for the course the student is enrolled in…