Question:1 Show all data from employee table where name should be in ascending and salary in descending order. Question:2 Show the total length of (eno, deptno), joined it and rename by function from the employee table? Question:3 Show the ename first 3 alphabets of manager? Question:4 Write a query that show the manager data like this. job *** MANAGER *** MANAGER ename JONES BLAKE Question:5 Calculate the percentage of any student and round to 0 digit? Question:6 Show the last date of December 2014? Question:7 Show the date of next data base class and rename by cs-400? Question:8 Convert today date to character?

Question:1 Show all data from employee table where name should be in ascending and salary in descending order. Question:2 Show the total length of (eno, deptno), joined it and rename by function from the employee table? Question:3 Show the ename first 3 alphabets of manager? Question:4 Write a query that show the manager data like this. job * MANAGER * MANAGER ename JONES BLAKE Question:5 Calculate the percentage of any student and round to 0 digit? Question:6 Show the last date of December 2014? Question:7 Show the date of next data base class and rename by cs-400? Question:8 Convert today date to character?

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

13- This clause in SQL join is based on all columns which have the same names, but the data types do not match. a. OUTER JOIN b. USING clause c. ON clause d. NATURAL JOIN
Write a query to show all record of job-history of those employees whose department number 60? SELECT first_name from employees where first_name like ‘S%’; SELECT first_name from employees where first_name like ‘_e%’; table Name :- EMP EDIT EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7839 KING PRESIDENT - 11/17/1981 5000 - 10 7698 BLAKE MANAGER 7839 05/01/1981 2850 - 30 7782 CLARK MANAGER 7839 06/09/1981 2450 - 10 7566 JONES MANAGER 7839 04/02/1981 2975 - 20 7788 SCOTT ANALYST 7566 12/09/1982 3000 - 20 7902 FORD ANALYST 7566 12/03/1981 3000 - 20 7369 SMITH CLERK 7902 12/17/1980 800 - 20 7499 ALLEN SALESMAN 7698 02/20/1981 1600 300 30 7521 WARD SALESMAN 7698 02/22/1981 1250 500 30 7654 MARTIN SALESMAN 7698 09/28/1981 1250 1400 30 7844 TURNER SALESMAN 7698 09/08/1981 1500 0 30 7876 ADAMS CLERK 7788 01/12/1983 1100 - 20 7900 JAMES CLERK 7698 12/03/1981 950 - 30 7934 MILLER CLERK 7782 01/23/1982 1300 - 10
Some rows of the table STUDENT are shown below: CODE NAME DEPARTMENT GPA YEAR 291 ALEX PSI 3.1 1992 938 MICHELE PHY 2.3 1992 931 JHON MD 3.3 2001 182 JOE MD 3.4 2002 190 REY PHY 2.0 2001 330 RON PSI 3.9 2001 You want the name all departments that have a department GPA average of 2004 greater than the global GPA average. Which query gives you the desired result? a. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT); b. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 AND AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT) GROUP BY DEPARTMENT; c. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT GPA FROM STUDENT GROUP BY DEPARTMENT); d. SELECT * FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT);
Resort that charges the highest You have to only develop a SQL query Write a query to display the resort name, rate of all the resorts that charges the highest. Sort the output on the resort name. Use:Resort,cabincost table) RESORT MANAGEMENT SYSTEM Town Pointofinterest Manager Number Varchar(30) varchar(30) PK pointID Number PK towniD PK manageriD Number townname varchar(30) varchar(30) describe Varchar(30) name state opentime varchar(10) address longitude varchar(30) closetime varchar(10) city varchar(20) varchar(30) Number Number latitude towniD Number phone varchar(15) FK summertemp wintertemp sealevel Number GIVES Resort Guest Review PK resortiD Number PK guestiD Number FK,PK guestlID Number resortName varchar(30) name varchar(30) FK.PK resortID Number street varchar(30) MANAGES address varchar(30) + dateofreview Date varchar(30) townname varchar(20) varchar(30) country BOOKS email comments varchar(150) FK townid Number phone varchar(15) starRating Number FK manageriD Number…
With the use of a group function, which clause can be used to restrict or filter the groups returned by an ad-hoc query?
You have a table named student having attributes student_name, id, batch, contact. Write a SQL query to display the names of all students in alphabetically increasing order.
b. Write a query to get the average salary and the total number of employees who work in the History department (in that order). c. Write a query to get the number of employees working in the History department with a job title of Head of Department.