write a query that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label.

Create a query to show the subject and the quantity of books in each category. Sort the results in ascending order by the number of books, then in ascending order by the subject name.

The invoices table contains the following columns: InvoiceId, CustomerId, InvoiceDate, BillingAddress, BillingCity, BillingState, BillingCountry, BillingPostalCode, Total. Create a query to return the CustomerId, InvoiceDate and Total columns from this table for only invoice totals over $20.

WEEK 1 ASSIGNMENT     Complete the following exercise: Create a student table. The student table needs to include the following columns: Student ID Student First Name Student Last Name Middle Name City State ZIP Code GPA Use the appropriate data types for each column. Create a Primary Key constraint for the table. Make sure all columns contain either a NULL or NOT NULL constraint.

Q1. Write a query to fetch the EmpFname from the Employeelnfo table in upper case and use the ALIAS name as EmpName.

In an ORDER BY clause, what are the two ways to refer to the columns to be used for sorting the results of the query?

Create a query for each of the following, save and print a copy: Books on a loan, using only BookID, title, author, and date taken. List of female readers who have at least loaned a book using only ReaderID, surname, first name, town, sex, book, title, and date taken.  List of books that have been taken at least once and whose date of publication is before January 2013.

Q. Please write SQL codes to query data from member tables based on below criteria  Please write a SELECT statement to display each member’sdata that member_id is an odd number. Please display the result in ascending order of the last_name. The result should be identical to below results: [Screenshot]

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 list the book title, checkout date, checkout due date and checkout in date for each book.