Write a query using mysql to display grant title, summary and grand amount which was received during the pastdecade. Sort the data by title & amount OrganizationResearchersINI P!O name VARCHAR(45)id INTname VARCHAR(45)O type VARCHAR (45)O departm en t VAROHAR(45)O addrecs VARCHAR(45)IndexesOo_jd INTIndexesGrantGrant_Researchersid INTManagerPid INTOtte VARCHAR(45)INI PIname VARCHAR(45)g_id INTsummary VARO-HAR(255)r_id INTamount DECIMAL(10,2)IndexesIndexesOstart_date DATEend_date DATEm_id INTo_id INTgrant_fiekds v| grant programr_d INTPid INTPid INTIndexesg_id INTOgjd INTf_d INTIndexesOpjd INTIndexesProgramFildtid INTPid INTHHOname VARCHAR(45)O directorate YARCHAR(45)Oname VARCHAR(45)IndexesIndexes

Answered: Write a query using mysql to display…

Write a query using mysql to display grant title, summary and grand amount which was received during the past decade. Sort the data by title & amount

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

fdhdhdh
You are given the following tables with column names in parentheses. COUNTRY (id (PK), name, population, income) CITY (id (PK), name, population, income, country_id (FK)) Write a query to display the countries and their income which have an income larger than the average income of all countries.
Create a query for displaying first name and salary of employees whose salary contains Length of 4 digits
Write a query that returns the EMP_NUM and Number of ratings he/she earned (based on EARNEDRATING table, call this Num_RTG), for those who had at least got 1 rating earned, but the number of ratings he/she earned must lower than the average number of ratings for all employees who had earned ratings before, and such employee has been served as “Copilot” before.
Write a query to display the employee number, last name, first name, salary "from" date, salary end date, and salary amount for employees 83731, 83745, and 84039. Sort the output by employee number and salary "from" date (Figure P7.31). EMP NUM EMP INAME EMP FNAME SAL FROM SAL END SAL AMOUNT 83731 VARGAS SHERON 20140-15 2015a-14 43.00 VARSAS SHERON 2015014 2016--13 481.00 83731 VARGAS SHERON 2016 04 201714 4.00 VARGAS SHERON 20170715 NUL S1040.00 SPICER DWAN 201102 2012-0-01 83745 SPICER 2012 0-2 2013-0-02 S7700.00 DWAN 3745 SCER DWAN 2013 o 2014-08-01 63470.00 SPICER DWAN 2014 08-02 2015-08-01 se.00 SPICER DWAN 2015O1 2010--31 71.00 SPICER DWAN 2016 O01 2017-08-01 7414.00 Figure P7.31 In the SQL Query do the following Select clause: Display the columns specified above in the problem statement from LGEMPLOYEE and LGSALARY_HISTORY tables From: Since we are displaying the information from these two tables specify the join condition here or in the where clause Where clause: Only…
Write a query to display the customer code, first name, and last name of all customers who have had at least one invoice completed by employee 83649 and at least one invoice completed by employee 83677. Sort the output by customer last name and then the first name.
Use the code below to write a query to display the movie title, movie year, and movie genre for all movies CREATE TABLE MOVIE ( MOVIE_NUM NUMBER(8,0) PRIMARY KEY, MOVIE_TITLE VARCHAR2(75) NOT NULL, MOVIE_YEAR NUMBER(4,0) CHECK (MOVIE_YEAR > 1900), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); INSERT INTO MOVIE VALUES (1234, 'The Cesar Family Christmas', 2011, 39.95, 'FAMILY', 2); INSERT INTO MOVIE VALUES (1235, 'Smokey Mountain Wildlife', 2008, 59.95, 'ACTION', 1); INSERT INTO MOVIE VALUES (1236, 'Richard Goodhope', 2012, 59.95, 'DRAMA', 2); INSERT INTO MOVIE VALUES (1237, 'Beatnik Fever', 2011, 29.95, 'COMEDY', 2); INSERT INTO MOVIE VALUES (1238, 'Constant Companion', 2012, 89.95, 'DRAMA', NULL); INSERT INTO MOVIE VALUES (1239, 'Where Hope Dies', 2002, 25.49, 'DRAMA', 3); INSERT INTO MOVIE VALUES (1245, 'Time to Burn', 2009, 45.49, 'ACTION', 1);
Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.
Write a query to list the book title, checkout date, checkout due date and checkout in date for each book.
Write a query to display student ID, First name and age. Sort the result based on student ID. [Note : Age can be calculated using DOB and give alias name as age] STUDENT COURSE Number(4) Varchar2(20) Varchar2(20) PK Studld PK courseid number(4) varchar2(20) number(2) number(7,2) FirstName LastName Street City CourseName Duration Varchar2(20) Fees Varchar2(20) DOB Date REGISTRATION PK-Primary key FK-Foreign key FK CourselD number(4) FK Studld number(4) DOJ Date
Write a query to display the book title, price and publisher name for all books.
Write a query to display the author ID and the number of books written by that author. Sort the results in descending order by number of books, then in ascending order by author ID (Figure P7.85). In the SQL Query do the following Select clause: Display author Id and count of author Id as “Books Written” From clause: WRITES table Where clause: Not needed as we are not limiting any data here Order by clause: “books written” desc, au_id asc