Question: Write the SQL statements to complete the following action on the Persons table. The Persons table contains two attributes FirstName and LastName. (a) Select all

Write the SQL statements to complete the following action on the Persons table. The Persons table contains two attributes FirstName and LastName.

(a) Select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"

(b) Select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jacke son"

(c) Insert a new record into the "Persons" table for Jimmy Jones

(d) deletes the record where the "FirstName" is "Peter" in the Persons Table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

LINK TO SQL DATA HERE ( had to add a space in between so it does not get blocked) https://drive.go ogle.com/file/d/1qHCkrods5K2V1syyS5IG6-Eb_3QQmud7/view?usp=sharing TABLE SQL DATA BELOW -- MySQL...

Q:

Directions:- Use SQL Server 2017 . See the images below and under TAL distributors write queries to perform steps 1 and 2 and 3. In Step 1 - name your table as Sales_Rep_Lastname. (The Last name in...

Q:

. Write the SQL code that answers the following question: Which classes are scheduled for Wednesdays at the Downtown Location? List the class name, the day, and the location. What SELECT statement...

Q:

For this assignment, run this on SQL Workbench: Querying SQL Servers 1 Use SQL to complete the following exercises. 1. Create a table named REP. The table has the same structure as the SALES_REP...

Q:

Answer the questions below for the table -- Create the petSupplies table drop table if exists petSupplies; CREATE Table IF NOT EXISTS petSupplies ( prodID VARCHAR(50), suppDescription VARCHAR(2000),...

Q:

Web programming 1.) MySQL: a.) Write SQL commands to create a database called my_db (Imk) b.) Write SQL commands to create the following tables; ustomer (CustomerlD, Persons (PersonI , CustomerName,...

Q:

SHOW ALL YOUR WORK. REMEMBER THAT PROGRAM SEGMENTS ARE TO BE WRITTEN IN JAVA. Assume that the classes listed in the Java Quick Reference have been imported where appropriate. Unless otherwise noted...

Q:

In the first picture I need #10,11,12 and 13 completed. In the second picture I need #14,15,16,17 and 18 completed. I need these queries in SQL view!!!!! Not design or Datasheet view. I do not need...

Q:

The owner of Colonial Adventure Tours knows the importance of the SQL language in database management. He realizes that he can use SQL to perform the same functions that you performed with queries in...

Q:

In the first picture I need #10,11,12 and 13 completed. In the second picture I need #14,15,16,17 and 18 completed. I need these queries in SQL view!!!!! Not design or Datasheet view. I do not need...

Q:

Suppose the Department of Energy would like to compare residential utility bills for different cities in the United States. A random sample of households was selected, and their utility bills for the...

Q:

A uniform rectangular plate, 40 cm long and 30 cm deep into the paper, hangs in air from a hinge at its top, 30-cm side. It is struck in its center by a horizontal 3-cmdiameter jet of water moving at...

Q:

When determinijg employee xompensation why is it important ti cjnseidee pay equity?

Q:

Analyse the financial statements: Interpret the financial statements of a real-world business. Question 1 Identify and explain two possible benefits and two possible limitations of ratio analysis....

Q:

List and explain the seven standard parts of a letter. (Objective 1)

Q:

What formatting guidelines should be followed if a letter is too long to fit onto one page? (Objective 1)

Q:

Ethics.Teamwork. In a group of three to five students, research on the Internet how blogs and instant messaging are being used in business. As a class, discuss your findings. (Objective 4)