1. Create a query to display 4 fields from the donor table. Each one should have an alias column header. 2. Create a query to display the unique or distinct states from the donor table that you just created. 3. Create a query to sort by city in descending order.

1. Create a query to display 4 fields from the donor table. Each one should have an alias column header. 2. Create a query to display the unique or distinct states from the donor table that you just created. 3. Create a query to sort by city in descending order.

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: Create a query for selecting all data from employees table by concatenating first name and last name…

A: SELECT first_name+ ','+last_name+'' AS Full_Name , Email + ', ' + Email_address + ' ' AS…

Q: Question #8. From invoices table, write a query to retrieve everything (all columns), plus, add an…

A: The query is given in the below step

Q: Which clause can be used to limit or filter the groups returned by a query that utilises a group…

A: To be determine: Which clause can be used to limit or filter the groups returned by a query that…

Q: Given the table customers which contains columns customer_id, first_name, last_name, and state, and…

A: SELECT C.LASTNAME, A.STATE, A.ZIP FROM CUSTOMER AS C INNER JOIN ADDRESS AS A on…

Q: WEEK 1 ASSIGNMENT#2 Complete the following exercise: Create a student table. The student table…

A: CREATE TABLE student ( Student_ID int NOT NULL PRIMARY KEY, Student_First_Name varchar(20) NOT…

Q: 2)Write a query to display the SSN and names of faculty members, and the course number and…

A: Please note that you may need to adjust the table and column names according to your database schema…

Q: Using the software.subscription table, pull all columns for subscriptions that have been cancelled.…

A: For the given database, if the user wants to select all the columns by giving the condition that the…

Q: 1. Write a query to alter the “Student” table, by setting the default value of Age > 20. 2. Drop…

A: Q. IN MYSQL 1. Write a query to alter the “Student” table, by setting the default value of Age >…

Q: Write a query to create a temporary table.

A: Question. Write a query to create a temporary table. Answer. Temporary table: A temporary table…

Q: Create a query to display all donors that live in City1, City2 or City3. Use the IN clause.

A: here In question ask query about IN clause Query: display all donors that live in City1, City2 or…

Q: If robots could take jobs away from humans why would they do it?

A: There are a few reasons why robots might be used to take jobs away from humans:

Q: Create a query to display all names where the first name starts with letters in the J-R range. Use…

A: SQL Language to display all name where first name start with j - r range . Using between

Q: Create a query to sort by city in ascending order and within each city the yrgoal in descending…

A: SQL Query: CREATE TABLE donors( donorid INT NOT NULL, name VARCHAR(20) NOT NULL, city…

Q: Create a Query with all products information whose price is >20.

A: Lets see the solution.

Q: .Write a query to list the first name and last name of all authors. Concatenate the first and last…

A: We need to select the name of both editor and author and do the union. The query for the same as per…

Q: Write a query to display the current salary for each employee in department 300. Assume that only…

A: We must take into account the compensation history kept in the figure 48 table in order to get the…

Q: a) Create the two tables above and insert the data in the rows accordingly. b) Write the standard…

A: Hi Student. Warm welcome from my side. Hope you are doing great. Here is your answer.

Q: Which of the following tables is followed by the outer join operator (+) in an OUTER JOIN query?

A: Given; Which of the following tables is followed by outer join operator in an OUTER JOIN query

Q: Query 2: Write a query to display every member in Ohio who made a payment greater than or equal to…

A: Select (First name, Lastname) from Payment where State = "Ohio" AND Amount>=300; The above…

Q: reate a query in query design view based on both tables to answer the question, What is the concert…

A: Query: Create query: CREATE TABLE `sponsor`( `concert_id` INT(50), `sponsor_name` VARCHAR(50),…

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: Create a query that uses any THREE of the tables (SCHOOL, DEPARTMENT, PROFESSOR, TECHNOLOGY &…

A: Creating all the three tables required for the question-For Department-create table…

Q: 1- What will be the result of the following query? Give explanation? CREATE TABLE Employee(Emp.jd…

A: By given instruction, a table will be created by using the given SQL query and some records will be…

Q: Create a copy of the Total Balances By Client query. Name the query Total Balances By State. Open…

A: To create a copy of the Total Balances By Client query and modify it to show the total balances by…

Q: Create a student table. The student table needs to include the following columns: Student ID Student…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Write a select statement to create the inner join of tables sec1310_table1 and sec1310_table2. The…

A: The above question is solved in step 2 :-

Q: 9. Create a query to show all the fields in EMPOLYEE and SPORTS table. Save the query as ES11 ' 10…

A: Answer 9: SELECT e.empno,e.empname,e.phone,e.place,e.doj…

Q: Create a query that lists all patients who have not had any appointment in the clinic in the last 2…

A: Note : As per guidelines , answering 1st 3 subparts of a question . Repost 4th part to get the…

Q: Create a query for displaying first name and salary of employees whose salary contains Length of 4…

A: Lets see the solution.

Q: Alter table supplierTransaction add column paymentDate as data type date, not null, default value of…

A: Query from table Purchase Order ALTER TABLE purchaseOrder RENAME COLUMN WHERE EXISTS (SELECT 1…

Q: Please write a query for dvdrental database. Please list first names of customers starting with…

A: Here is the query for the following question: Query: SELECT DISTINCT first_name FROM customer…

Q: WEEK 3 ASSIGNMENT Complete the following exercise: Using the student table you created in week…

A: Note: Due to company policies I am compelled to solve only the first three sub parts of the…

Q: WEEK 2 ASSIGNMENT Complete the following exercise: Using the student table you created in week…

A: Note: Due to company policies I am compelled to solve only the first three sub parts of the…

Q: Which function does the PRIMARY KEY clause perform in table creation? It ensures that’s non-NULL…

A: Answers:- The primary key constraint is a uniquely identifies each record in the table. The Primary…

Q: Create a View to show the city name of any location that has a department. Only show the city name…

A: SQL Query:- A query is a request for data or information from a database table or set of databases.…

Q: d. write a query to retrieve the name of graduate student and student advisor name of all graduate…

A: The query works for both ms sql server and mysql.

Q: 1.CREATE TABLE contacts ( last_name VARCHAR(30) NOT NULL, first_name VARCHAR(25) NOT NULL, birthday…

A: The query is given here to create a table ans set primary key as last_name and first_name. The query…

Q: Create a query for displaying list of employees who joined in the second half of year ‘07’;

A: Lets see the solution.

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

1. Create a query to display 4 fields from the donor table. Each one should have an alias column
header.
SQL> desc donor
Name
Null?
Туре
2. Create a query to display the unique or distinct states from the donor table that you just created.
IDNO
VARCHAR2 (5)
VARCHAR2 (15)
VARCHAR2 (15)
3. Create a query to sort by city in descending order.
NAME
STADR.
4. Create a query to sort by city in ascending order and within each city the yrgoal in descending
CITY
VARCHAR2 (10)
order.
STATE
VARCHAR2 (2)
5. Create a query to concatenate the street address so you print stadr followed by a comma and a
space and then city followed by a comma and a space and then state followed by a space and
then zip.
ZIP
VARCHAR2 (5)
DATEFST
DATE
YRGOAL
NUMBER (7,2)
CONTACT
VARCHAR2 (12)

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 3 images

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

Question #10.Write a query to retrieve invoice_number, invoice_date, and “Balance Due” from the invoices table.Balance Due can be calculated by subtracting payment and credit from the original invoicedamount. Make sure to only select rows with positive “Balance Due” and sort the results basedon Balance Due. Refer to the sample result screen below.
Given a small company database tables below. Create the database and tables for the company and answer all the questions below. LINE CUSTOMER VENDOR INV_NUMBER LINE_NUMBER P_CODE LINE_UNITS LINE_PRICE Cus CODE CUS_LNAME CUS_FNAME CUS_INITIAL cus AREACODE CUS_PHONE CUS_BALANCE V_CODE V_NAME V_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER 1000 3 23100-HB 0.05 10010 Ramas Afred 015 844-2573 21225 Bryson, Ine. Smithson 015 223-3234 TN 1006 4 89-WRE-Q 256.00 10011 Dunne Leona 713 804-1238 21220 SuperLoo, Inc. Flushing 04 215-8006 FL N 1 13-Q2/P2 2 14.00 1007 10012 Smith Kathy 015 804-2205 345.88 21231 DSE Supply Singh 815 228-3246 TN 1007 254778-2T 4.00 10013 Olowski Paul 815 804-2100 530.75 21344 Gomez Bros. Ortega 815 889-2546 KY N 1008 1 PVC23DRT 5.87 10014 Orlando Myron le15 222-1872 22507 Dome Supply Smith 01 e78-1419 GA IN 1008 2 WR3/TT3 3 110.05 10015 OBrian Amy 713 442-3381 23110 Randsets Ltd. Anderson 001 078-3008 GA 1008 3 23100-HB 0.05 10010 Brown James 015 297-1228 221.19 24004…
Write a query to retrieve the Fname and Lname in a single column as “FullName”. The first name and the last name must be separated with space.
Insert at least three rows into your EMPLOYEE_xx table. Use the next value of the sequence you created , EMPL_SEQUENCE_xx as the value for the employee ID for every row inserted. You may choose values for the other columns Test your constraint on the rate column by trying to update a row in the EMPLOYEE_xx table with the value of 6 used for the Pay Rate (you choose the row). Drop your EMPLOYEE_xx table and make sure it HAS been purged from the recyclebin
Write a query to fetch all the records from the Employee table ordered by Lname in descending order and Department in the ascending order.
create tables appointments having columns appointment id as primary key, appointment time, appointment date, doctor id doctors having doctor id as primary key, doctor name providers having provider id as primary key, provider first name, last name, username, password, office code. Now create a provider first name as Lilly , Last name as Brooks, username as Lily_777, password as Brooks_666. Validate on the database also show me the appointments with Dr.Alex at 10.30A.M
use the following picture to answer question below question 10 Insert below record to the Customer table. Assuming there is a Default Constraint on the City column, insert default value of Default Constraint. Insert Null values for State and Phone columns. CustID: 180 LName: Pourhadi FName: Farhad
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.
Task Write a query to retrieve the records of students who have their total marks greater than or equal to 500 Total marks refer to the sum of the marks of a single student. The result should be in the following format • STUDENT ID • SUM OF MARKS The result should be sorted in descending order by STUDENT D Table description Table: marks Name STUDENT_ID Type Description INTEGER This is the student's unique ID These are the marks obtained STUDENT MARKS INTEGER
1. Write a query to display customer name, product and category with prices between 5 and 25 (without using between), save as q1. 2. Write a query to remove duplicate values from the category column of the customer table, save as q2. 3. Write a query to arrange the product price in descending order, save as q3.