A Guide to SQL
9th Edition
ISBN: 9781111527273
Author: Philip J. Pratt
Publisher: Course Technology Ptr
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 2TD
Program Plan Intro
Insert values:
Inserting values comes under Data Manipulation Language (DML).
- The INSERT command in SQL is employed to add records to an existing table.
Syntax for inserting values into the table is as follows:
INSERT INTO TABLE_NAME VALUES ('DATA 1', 'DATA 2');
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Orders Table:
OrderID, CustomerID, Order Date, TotalAmount
Customers Table:
CustomerID,CustomerName.
Retrieve the customer name and order date
for each order placed by customers who have
made more than two orders.
question 15
please use the picture below to answer the following question
Display customer number, customer name, and location for customers whose Customer_name starts with letter C. Sort the result based on customer number.
Employee_id Name Salary
1001 Annie 6000
1009 Ross 4500
1018 Zeith 7000
This is Employee table.
Which of the following employee_id will be displayed for the given query?
SELECT * FROM employee WHERE employee_id>1009;
a) 1009, 1001, 1018
b) 1009, 1018
c) 1001
d) 1018
Chapter 3 Solutions
A Guide to SQL
Ch. 3 - Prob. 1RQCh. 3 - How do you delete a table using SQL?Ch. 3 - Prob. 3RQCh. 3 - Prob. 4RQCh. 3 - Prob. 5RQCh. 3 - Prob. 6RQCh. 3 - Prob. 7RQCh. 3 - Prob. 8RQCh. 3 - Prob. 9RQCh. 3 - Prob. 10RQ
Ch. 3 - Prob. 11RQCh. 3 - Prob. 12RQCh. 3 - Prob. 13RQCh. 3 - Use SQL to complete the following exercises....Ch. 3 - Prob. 2TDCh. 3 - Prob. 3TDCh. 3 - Prob. 4TDCh. 3 - Prob. 5TDCh. 3 - Prob. 6TDCh. 3 - Prob. 7TDCh. 3 - Prob. 1CATCh. 3 - Add the following row to the ADVENTURE_TRIP table:...Ch. 3 - Prob. 3CATCh. 3 - Prob. 4CATCh. 3 - Prob. 5CATCh. 3 - Prob. 6CATCh. 3 - Review the data for the TRIP table in Figure 1-5...Ch. 3 - Colonial Adventure Tours would like to increase...Ch. 3 - Prob. 1SCGCh. 3 - Add the following record to the VACATION_UNIT...Ch. 3 - Delete the VACATION_UNIT table.Ch. 3 - Prob. 4SCGCh. 3 - Prob. 5SCGCh. 3 - Prob. 6SCGCh. 3 - The SERVICE_REQUEST table uses the CHAR data type...
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
- Add the following record to the VACATION_UNIT table: condo ID: 20; location number: 2; unit number: A04; square feet: 1680; bedrooms: 3; bathrooms: 3; condo fee: 775; and owner number: BL720. Display the contents of the VACATION_UNIT table.arrow_forwardConsider Following Tables. Student ( regNo, sName, sCity, sCGPA, sAge) Course ( cCode, cName, credit_hours) Enrollment (regNo, cCode, semester, Grade) NOTE: you must use “JOINS” query only. Display names of all those students who have “A” Display student name and ccode of all those students who have ‘F’ grade in 5th Display data of all those students who have enrolled at least 10 Display grade of ‘Ali’ in course ‘CS101’. Display all courses of ‘Amir’ along with grade, also display names of courses which are not yet enrolled by ‘Amir’. Display course names along with number of enrolled student in it. If no one has yet enrolled that particular course, it must display ‘0’ in number of enrollment Display list of courses which are taught in 7th (course name must not repeat) Display list of all students by name and course name they have Display names of students and names of courses they have enrolled. Also display student’s name that have not enrolled any course Display all those students…arrow_forwardORACLE SQL STAYWELL The table being used is the PROPERTY table. Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square footage, bedrooms, floors, monthly rent, and owner’s last name for every property in which the number of bedrooms is three.arrow_forward
- Table Name : Item Column name Datatype Varchar2 Varchar2 Varchar2 Number Size Constraint ID Primary key ITEM NAME MANUFACTURER PRICE |DELIVERY DATE 8 30 8. Not Null Date Table Name : Customer Details Column name Constraint Datatype Varchar2 Size ID Foreign Key Varchar2 Varchar2 CUSTOMERNAME 30 LOCATION 30 CUSTOMERID Varchar2 8 QUANTITY Number 8 Data for Item table ID ITEMNAME MANUFACTURER | PRICE DELIVERY DATE 09001 COMPUTER DELL 35000 12-June-2004 09002 | KEYBOARD INTEX 10000 25-June-2004 09003 COMPUTER | SAMSUNG 09004 COMPUTER | LENOVO 32000 18-Feb-2004 37000 03-April-2004 57000 20-May-2004 09005 | LAPTOP DELL Data for Customer Details table CUSTOMERID QUANTITY 525 ID CUSTOMERNAME CITY 09001 | KALIFA 09002 ABDUL AZIZ 09003 ABDUL 09004 | МОНАМED 09005 AHAMED NIZWA CO001 BARKA 8400 5250 525 CO002 SOHAR C0003 NIZWA BARKA CO001 CO004 3150arrow_forwardQ1- List all employees whose job_id is IT_PROG and hired after 01-JAN-95 and earning more than5000.Q2- List all employee except those with employee_id 101, 102, 103, 104 and 105Q3- Display the city attribute from locations table. Show the ones that contain “South” in the city.Sort the list in descending order.Q4- Display the first name, last name, salary, manager id and job id of all employees whose last fourcharacters of job id ends with “LERK”.Q5- Display the first name, last name and salary of all employees. Round the salary to the nearestunit of 1000 (ex. Salary=4500 New Salary=5000). Label the column as "New Salary".arrow_forwardYou 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 departmentarrow_forward
- Table: Employee | Column Name| Type| | id | int | | int | | salary +- -------+ id is the primary key column for this table. Each row of this table contains information about the salary of an employee. Write an SQL query to report the second highest salary from the Employee table. If there is no second highest salary, the query should report null.arrow_forwardList every column in the Condo_UNIT table and its associated type.arrow_forward9. Find the total amount of tax paid by resident of NJ Hint: The tax cost stored in tax_amount column in the orders table The state name stored in state column in the addresses tablearrow_forward
- Guest details and Total Charges paid Display guest details who paid total charges RS.50000 and above. Write a query to fetch Guest id, Guest name and Sum of total charges. Give alias name to total charges as TOTALPAID. Sort the result by guest id. RESORT MANAGEMENT SYSTEM Pointofinterest Town Manager PK pointiD Number PK towniD Number PK manageriD Number townname Varchar(30) describe Varchar(30) name varchar(30) varchar(30) varchar(30) + varchar(30) state opentime varchar(10) address varchar(30) longitude latitude city varchar(20) closetime varchar(10) phone varchar(15) FK townID Number summertemp Number wintertemp Number sealevel Number Resort Guest Review PK resortiD Numbes gasanb Number varchar(30) PK guestiD FK.PK guestID Number resortName varchar(30) name FK.PK resortiD Number varchar(30) street ANAES address varchar(30) ++ dateofreview Date townname varchar(30) varchar(20) varchar(30) country email comments varchar(150) FK townid Number phone varchar(15) starRating Number FK…arrow_forwardGuest details and Total Charges paid Display guest details who paid total charges RS.50000 and above. Write a query to fetch Guest id, Guest name and Sum of total charges. Give alias name to total charges as TOTALPAID. Sort the result by guest id. RESORT MANAGEMENT SYSTEM Pointofinterest Town Manager PK towniD Number manageriD Number PK pointiD Number PK townname Varchar(30) describe Varchar(30) name varchar(30) varchar(30) varchar(30) + varchar(30) state opentime varchar(10) PC address varchar(30) longitude varchar(20) varchar(15) closetime varchar(10) latitude city phone FK townID Number summertemp Number wintertemp Number sealevel Number Resort Guest Review PK resortiD Number gasanb Number varchar(30) PK guestiD FK.PK guestID Number resortName varchar(30) name FK.PK resortiD Number street varchar(30) address varchar(30) + dateofreview Date townname varchar(30) varchar(20) varchar(30) country email comments varchar(150) FK townid Number Number Number phone varchar(15) starRating FK…arrow_forwardDelete all properties in the LARGE_PROPERTY table for which the owner number is BU106.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage