Concept explainers
DISTINCT Keyword: “DISTINCT” keyword is used to avoid redundant data (removing duplicate values) from a column. The syntax for “DISTINCT” keyword is as follows:
Syntax:
SELECT DISTINCT column_Name FROM table_Name;
AND Operator:
In SQL, “AND” keyword is used in order to check two and more than two conditions. This usually works well with “WHERE” clause.
Syntax:
SELECT * FROM table_Name WHERE condition1 AND condition2;
ORDER BY Clause:
SQL contains “ORDER BY” clause in order to sort rows. The values get sorted in ascending as well as descending order. The keyword used to sort values in ascending order is “ASC” and for descending order is “DESC”. By default, it sorts values by ascending order.
Syntax:
SELECT column_Name1, column_Name2 FROM table_Name ORDER BY column_Name2;
Trending nowThis is a popular solution!
Chapter 5 Solutions
A Guide to SQL
- Part II: Complete the following exercise: Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state. Using your student table select all students with ZIP codes between “23164” and “98164”. Using your student table select all students where states are in Florida and New York. Using your student table select all students where the last name starts with an “S” and is at least three characters in length.arrow_forward4. Update the name of the student to "John Doe" where its id is 10. Enter your answer 5. Modify the "student" table by adding "address" column/field as string and allows null.arrow_forwardShow the list of courses numbers that are taken at least once by students. The course should appear once even if the course is taken multiple times.arrow_forward
- Find the album title, band name, format, and total length of all albums released since January 1, 2000. Order from longest to shortest. Try to return the format as the word "single" or "double" rather than just the store value "s" or "d". Try to get the total length to look like a reasonable time value rather than just a big number. Please use the same table names as below in the image.arrow_forwardAdd two columns to the EMPLOYEES table. One column, named EmpDate, contains the date of employment for each employee, and its default value should be the system date. The second column, named EndDate, contains employees’ date of terminationarrow_forwardTask 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.arrow_forward
- List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.arrow_forwardList unique first (first_name) and last names (last_name) of customers (CUSTOMER table) who rented a movie (RENTAL table) between '2011-06-01' and '2012-01-01’ (rental_date). Sort by last_name. The common key is CUSTOMER_ID.arrow_forwardWho has rented movies in Japanese language? Return only the first five distinct results in alphabetical order by last name.(Hints: In the language table, there is a field “name” that contains the film language names.) Display: first name and last namearrow_forward
- after revisiting the last table, what number should replace the value in the intersection of Albert's row and column Task 3arrow_forwardQuestion 15 Display the last name, salary, and commission for all employees who earn commissions. Sort data in descending order of salary and commissions.arrow_forwardUsing software.subscriptions table, pull all columns for subscriptions that have been cancelled.arrow_forward
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage