2-Displaye the name Nd department number of all employees working indepartments 10 and 30 in alphabetical order of names.3-Displaye the name, function and salary of all employees whose functionis clerk or analyst and their salary is not eqaul $1000,$3000 or $50004-Display the name and salary of employees earning more than $2850.5-Display the name and salary of employees whose salary isn't includedbetween $1509 and $2850.6- Write a query that displays today's date. Name the column Date7-Display employee number, name, salary and salary plus 15% as aninteger. Name this column new salary8- for each employee displaye the name and calculate the number ofmonths between today and their hire date Name the column monthworked. sort the result in descending order of number months of work.Round the number of months to an integer9- write a query that displays the names of employees with the first letterin uppercase and the following in lower case, and the length of their nameand this for employees whose names begin with J, A, OR.M., give eachcolumn an appropriate title.10-Display the name of employees whose third letter of their name is an A.I want to solve number 56 78910

According to the Bartleby guideline, we are supposed to answer only first 3 similar question at a…

5-Display the name and salary of employees whose salary isn't included between $1509 and $2850. 6- Write a query that displays today's date. Name the column Date 7-Display employee number, name, salary and salary plus 15% as an integer. Name this column new salary

5-Display the name and salary of employees whose salary isn't included between $1509 and $2850. 6- Write a query that displays today's date. Name the column Date 7-Display employee number, name, salary and salary plus 15% as an integer. Name this column new salary

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

Related questions

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: SOSL Query: Create a SOSL Query in salesforce to find the test keyword in the whole organization.…

A: Here we have to create an SOSL query in salesforce to find the test keyword. Here I have syntax for…

Q: nt that

A: The explicit join syntax makes use of two keywords, ON and JOIN. ON keyword is used to specify the…

Q: write a query that displays employee last names, department numbers, and all the employees who work…

A: Here, SELECT statement is used along with the ON, WHERE, and ORDER BY clause.

Q: QUESTION 15 use the follwoing picture to answer the question Write a select statement which should…

A: Select INVENTORY.ITEM_SIZE, INVENTORY.COLOR, INVENTORY.CURR_PRICE,ORDER.ORDER_IDInner join on

Q: The Book table has the following columns: ID Title Author Genre Year Price Complete the SELECT…

A: The question is asking for a SQL query that will return each genre and the total number of books in…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: SQL code: to add an additional column ex: ALTER TABLE chicken ADD dish varchar(30) Question: How…

A: Alter table is used to add or modify table structure. In sql it is possible to add default values…

Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…

A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…

Q: Some rows of a User table are shown below: User ucode name phone scode 7 Alex 847 - 3902…

A: Names and phone numbers are among the details about different users that are included in the User…

Q: enter null value in a column where the Unique constraint is assigned to that column

A: enter null value in a column where the Unique constraint is assigned to that column True or False

Q: Write a SELECT statement that joins the Instructors and Courses tables and returns these columns:…

A: To accomplish this task, you can use a SQL SELECT statement that performs a LEFT JOIN between the…

Q: n SQL When you use ALTER TABLE to add a column, the new column: Select one: a. Will not be created…

A: ANSWER : B Becomes the last column in the table

Q: Insert into the LARGE_PROPERTY table the office number, address, bedrooms, floors, monthly rent, and…

A: Columns from the property table that have a square footage of more than 1,500 square feet need to be…

Q: 1) Display the Name of the Product and the corresponding name of the supplier of that Product.…

A: Structured Query Language (SQL) allows use of JOIN operation to obtain information from two or more…

Q: Write the SQL statement that will display all the products and another column that will increase…

A: We can display all the columns using * and in addition to that another column is displayed

Q: Write a query that returns the Staff ID for the staff member who is involved in the most rentals

A: The goal of this search is to identify the employee who handles the most rentals. In order to…

Q: Write in SQL a command that creates the table Customers according to the above description (2…

A: SQL answers to the above first 3 questions are in step2 as per our guidelines we are supposed to…

Q: Orders Table: OrderID,CustomerID, Order Date, TotalAmount Customers Table: CustomerID, CustomerName.…

A: In this question we have to create a query to retrieve the customer name and order date for each…

Q: 3. Write a query that retrieves the following results (note the column names and order of results):

A: The required result needs to fetch below columns : Pub_id -> from publisher table Publisher's…

Q: Result : Honda Toyota 2 3 O Select Make, Count(Make) FROM Auto Group By Make; Select Make,…

A: COUNT() is an aggregate function that counts the number of rows returned by a query.The HAVING…

Q: Which clause of a SQL Select statement is required if we want to display aggregate data by category…

A: Answer: 5) GROUP BY

Q: Display the last name, salary, and commission for all employees who earn commissions. Sort data in…

A: In the above question, needs to find out only those employee's last name, salary, and commission who…

Q: Part II: Complete the following exercise: Using a subquery, select student first name where the…

A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Q: Task 9: Use a subquery to find the sales rep ID, first name, and last name of each sales rep who…

A: 9. SELECT rep.rep_ID,rep.last_name,rep.first_name FROM rep WHERE rep.rep_ID IN (SELECT rep_ID FROM…

Q: ctional). Your class should have a constructor that sets all the properties, and a toString method…

A: the code is an given below :

Q: How can you concatenate columns in a query?

A: To concatenate the columns in a query. In the SQL, You can concatenate two or more columns in a…

Q: What is the function of a column qualifier? When do you have to use one?

A: Column qualifiers are used for distinct access of the data values in order to identify them…

Q: For every invoice, display the invoice number, invoice date and the total dollar amount for all…

A: Dear student your query get the error because inv_number exist in the two table so you have to…

Q: Create a query that that returns staff members’ names (excluding doctors), their hourly rates,…

A: Create a query that that returns staff members’ names (excluding doctors), their hourly rates,…

Q: 10-Create a products table that has product id, product name, and price fields. Write a query to…

A: Algorithm : 1) Create the table products. 2) Insert some values in the table. (I have added 4…

Q: Find the ID, first name, and last name of each customer whose first name begins with the letter S.

A: The question has been answered in step2:

Q: how is duplicate column prefixed when duplicate column appear in Join Query? a) Table name followed…

A: The question is asking about the way to prefix a duplicate column when it appears in a Join Query in…

Q: The InstantRide Finance team also wants to analyze travels where more than the average discount rate…

A: For given InstantRide Finance team database, need to write query to create a SELECT statement which…

Q: column name

A: We need to select Which column name is valid? We've to Select one from: a. NUMBER_1$ b. NUMBER c.…

Q: in sql The NEXTVAL virtual column returns the integer that was most recently supplied by the…

A: The NEXTVAL virtual column returns the integer that was most recently supplied by the sequence…

Q: In an ORDER BY clause, what are the two ways to refer to the columns to be used for sorting the…

A: Question :- In an ORDER BY clause, what are the two ways to refer to the columns to be used for…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

2-Displaye the name Nd department number of all employees working in
departments 10 and 30 in alphabetical order of names.
3-Displaye the name, function and salary of all employees whose function
is clerk or analyst and their salary is not eqaul $1000,$3000 or $5000
4-Display the name and salary of employees earning more than $2850.
5-Display the name and salary of employees whose salary isn't included
between $1509 and $2850.
6- Write a query that displays today's date. Name the column Date
7-Display employee number, name, salary and salary plus 15% as an
integer. Name this column new salary
8- for each employee displaye the name and calculate the number of
months between today and their hire date Name the column month
worked. sort the result in descending order of number months of work.
Round the number of months to an integer
9- write a query that displays the names of employees with the first letter
in uppercase and the following in lower case, and the length of their name
and this for employees whose names begin with J, A, OR.M., give each
column an appropriate title.
10-Display the name of employees whose third letter of their name is an A.
I want to solve number 56 789
10

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Guidelines:-

VIEW

Step 2: Explanation:-

VIEW

Solution

VIEW

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

If a particular column is not allowed to be null, what is the result if the column is left empty?
question 11 please use the picture below to answer the following question Write a SQL statement to change the value of the column Invoice_Date (new_invoice table) to today's date for Customer ID 10.
SQL: Dog DataIn each question below, you will define a new table based on the following tables.CREATE TABLE parents ASSELECT "abraham" AS parent, "barack" AS child UNIONSELECT "abraham" , "clinton" UNIONSELECT "delano" , "herbert" UNIONSELECT "fillmore" , "abraham" UNIONSELECT "fillmore" , "delano" UNIONSELECT "fillmore" , "grover" UNIONSELECT "eisenhower" , "fillmore";CREATE TABLE dogs ASSELECT "abraham" AS name, "long" AS fur, 26 AS height UNIONSELECT "barack" , "short" , 52 UNIONSELECT "clinton" , "long" , 47 UNIONSELECT "delano" , "long" , 46 UNIONSELECT "eisenhower" , "short" , 35 UNIONSELECT "fillmore" , "curly" , 32 UNIONSELECT "grover" , "short" , 28 UNIONSELECT "herbert" , "curly" , 31;CREATE TABLE sizes ASSELECT "toy" AS size, 24 AS min, 28 AS max UNIONSELECT "mini" , 28 , 35 UNIONSELECT "medium" , 35 , 45 UNIONSELECT "standard" , 45 , 60; Q2: By Parent HeightCreate a table by_parent_height that has a column of the names of all dogs that have a parent,ordered by the height…
Write a SELECT statement that uses the ranking functions to rank products by the total quantity sold. Return these columns: The product_name column from the Products table A column named total_quantity that shows the sum of the quantity for each product in the Order_Items table A column named rank that uses the RANK function to rank the total quantity in descending sequence A column named dense_rank that uses the DENSE_RANK function to rank the total quantity in descending sequence
SOQL Salesforce: Write a SOQL query to find out the all account which the name starting with the character p.
Which clause of a SQL Select statement is required if we want to display aggregate data by category such as total population by state, department, etc.? Question 40 options: 1) GROUP BY 2) ORDER BY 3) WHERE 4) FROM 5) SELECT
How do you indicate that a column alias should be used?
A query may use any one of six LINQ operators.
SQL
You have been told that you need to store the zip code for employees. Add a column to the EMPLOYEE table which will be used to store each employee’s zip code Update two rows in the EMPLOYEE table and assign a zip code (must have a WHERE clause). (you MAY use 1 or 2 statements) Write a query that includes each employee's last name, department name (not ID), and salary for each employee whose salary is less than the average for their department
ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear
7. Use the UNION operator to generate a result set consisting of three columns from the Products table: Discount status A calculated column that contains a value of DISCOUNTED or FULL PRICE Product_name The product_name column discount_percent The discount_percent column If the product has a discount_percent greater than 0, the Discount_status column should contain a value of DISCOUNTED. Otherwise, it should contain a value of FULL PRICE. Sort the final result set by product_name.