Does this SQL query work for thisquestion?user_id3437315 janedo 2.03437316 princessluvB93437317 sköter 413action_id requester_id11037392213810223usernameSELECTusername2331234usersemailjanedoe2.0@email.comprincessluv6996@email.co 600017mskater4lf3@email.comfriend requestsrequestre id3437315friend_count54384431231232583action_timestamp2015-03-15:00:01:052015-03-15 00:01:072015-03-15:00-01:08Question 2: Write a SQL query that returns the three users who have sent the mostfriend requests. Your query should return the username and number of requests sent.COUNT(requester ]d)FROM users uJOIN friend requests fON frequestee id-u.user.idGROUP BY usernameORDER BY COUNT(requester_id)LIMIT 3;action takenRequestedAcceptedRejected

Please find the detailed answer in the following steps. CREATE TABLE `users` ( `user_id` int(11)…

Question 2: Write a SQL query that returns the three users who have sent the most friend requests. Your query should return the username and number of requests sent. SELECT username. COUNT(requester ]d) FROM users u JOIN friend requests fON frequestee_id u.user.id GROUP BY username ORDER BY COUNT(requester_id) LIMIT 3;

Question 2: Write a SQL query that returns the three users who have sent the most friend requests. Your query should return the username and number of requests sent. SELECT username. COUNT(requester ]d) FROM users u JOIN friend requests fON frequestee_id u.user.id GROUP BY username ORDER BY COUNT(requester_id) LIMIT 3;

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Examine the EMPLOYEES table and the given SQL statement: EID Name Dept Salary 1001 Aminah IT 600 1002 Zainab Admin 400 1003 Tafal IT SELECT Name, Dept, Salary FROM employees WHERE name LIKE'_a%' AND salary IS NULL; Which of the following will be the output after executing the statément? a. Name Dept Salary Tafal IT b. Name Dept Salary Aminah IT 600 Zainab Admin 400 Name Dept Salary Zainab Admin 400 Name Dept Salary Aminah IT 600 DELL
Write SQL statements to the following queries. Retrieve customer FULL_NAME which full name (starts with uppercase letter N and end with lowercase letter i) or (starts with uppercase letter K and end with lowercase letter d) in ascending order of FULL_NAME.
Write SQL queries for the following. Display details of those patients whose age is either 25 or 36 or 29 without using comparison operator. Display first name and last name of those doctors whose salary is less than or equal to 77,000 and greater than or equal to 50,000 using between operator. Display details of those doctors who neither belong to Isb nor Rwp nor Multan without using in and like operator. Display full name of doctors whose first name is other than Tania. Display first name of doctors whose first name contains any of vowels (a,e,i,o,u). Display names of those patients whose name’s second letter is neither ‘a’ nor ‘d’ Display details of those male patients whose age is 25 or 36. Display details of those patients whose name contains less than 5 characters. Display first 4 doctors who are earning least salary. Display details of all patients in such a way that female patients are shown before male patients. Display the unique cities from doctor table. Display all…
*/By Using the following schema, answer the following SQL queries and commands: Product(P_code,P_name, P_price, P_amount,vend_code) Vender(vend_code, vend_fname, vend_areacode, vend_phone) 1- find the venders code who sell microwaves products in area that has code 345 and their names include "mur". 2- find the code, name and vender code of product that has price between 1500$ and 2500$ and the product that has price between 4800$ and 5600s. 3- Find the name, and code of venders who had 5 microwaves that has price less than 3500$. 4- Find the phone numbers of venders who sell Televisions. 5- Delete the records of venders who their first name is 'smith'
Write an SQL query that will show all data from the Customers table andOrder By State.
Table Name Column Names REGIONS REGION ID, REGION NAME COUNTRIES COUNTRY_ID, COUNTRY_ NAME, REGION_ID LOCATIONS LOCATION ID, STREET ADDRESS, POSTAL CODE, CITY, STATE PROVINCE, COUNTRY ID DEPARTMENTS DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION ID EMPLOYEES ΕMPLOYEE D, FIRST NΑΜΕ, LAST NAMΕ, EΜAL , PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID JOB HISTORY EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARΤΜΕNT ID JOBS JOB ID, JOB TITLE, MIN SALARY, MAX SALARY
order db orderid int custid int itemcode int orderquantity int deliverydate date modeofpayment char(1) date_of_order date
I need the answer as soon as possible
QUESTION 2. Write a PL/SQL PROCEDURE that can list the Top-N customers (id and name) and the amounts spent in a specified year together with their rank. The customer rank can be obtained from the function created in the previous question. The total purchase is calculated for each customer using the quantity and price columns. The total purchased is sorted from the highest to the lowest. The procedure will have two input parameters: year (NUMBER) and TOP_N (NUMBER). Hint: • use ONE EXPLICIT CURSOR (corresponding to one select statement). • Us the topN technique (from clause subquery) and rownum to limit the customers. Expected Output for Top 3 customers in 2018 using: execute topSpenders (2018. 3) 3 Gary Jenkins s422.64 Excellent 45 Fred Fontain $359.21 Excellent 16 Ralph Foster $351.64 Excellent Expected Output for Top 10 customers in 2018 using: begin topSpenders(2018,10 end: 3 Gary Jenkins s422.64 Excellent 45 Fred Fontain $359.21 Excellent 16 Ralph Foster $351.64 Excellent 81…
Write a query in SQL to display all the data of customers, in Table customers, that live in New York or California SELECT city FROM customers WHERE city = 'New York' OR city = 'California' SELECT * FROM customers WHERE city = 'New York' AND city = 'California' SELECT * FROM customers WHERE city = 'New York' OR city = 'California' SELECT ALL FROM customers WHERE city = 'New York' OR city = 'California' %3D
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…
SQL ( ORACLE SQL DEVELOPER ) : THIS IS FIRST , SECOND AND THIRD TABLE for the Task 1 to solve : create table author_45( auth_name char(50), gender char(1), age number(3), nationality char(50), PRIMARY KEY (auth_name) ); create table book_45( isbn number(10), title char(50), ver_no number(2), publisher char(50), PRIMARY KEY (isbn) ); create table writtenBy_45( isbn number(10), auth_name char(50), yr_published number(4), price number(3), no_copy number(4), PRIMARY KEY (isbn,auth_name), foreign key (isbn) references book_45, foreign key (auth_name) references author_45 ); insert into author_45 values ('Benoit','F',42,'French'); insert into author_ 45 values ('Antonini','M',33,'Italian'); insert into author_ 45 values ('McAven','F',31,'Australian'); insert into author_ 45 values ('Williams','M',90,'British'); insert into book_45 values (101,'atabases',1,'Possum'); insert into book_45 values (202,'SQL Primer',2,'Hall'); insert into book_45 values…