Consider an Animal table with the following columns: • ID - integer, auto increment, primary key • Name - variable-length string Breed variable-length string, must be one of the following: - Holsteiner, Paint, Saddlebred • Height - decimal number, must be ≥ 10.0 and ≤ 20.0 • BirthDate - date, must be > Jan 1, 2010 Write the SQL Query to make the following updates: 1. Change the name to Luck and birth date to May 1, 2015 for animal with ID 2. 2. Change every breed to NULL for animal born on or after December 20, 2015. 3. Delete all rows for animals born before March 13, 2013.

Consider an Animal table with the following columns: • ID - integer, auto increment, primary key • Name - variable-length string Breed variable-length string, must be one of the following: - Holsteiner, Paint, Saddlebred • Height - decimal number, must be ≥ 10.0 and ≤ 20.0 • BirthDate - date, must be > Jan 1, 2010 Write the SQL Query to make the following updates: 1. Change the name to Luck and birth date to May 1, 2015 for animal with ID 2. 2. Change every breed to NULL for animal born on or after December 20, 2015. 3. Delete all rows for animals born before March 13, 2013.

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: in pl/sql ,use Cursor to get all the records from table job_history for employee_id 121

A: pl/sql code for the above question is solved in step 2:- assume table job_history has columns…

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: In SQL, write the appropriate statements to insert default values for these three tables, each table…

A: Prescription table: INSERT INTO prescription (pre_no,pre_date,pre_amount)VALUES (10,12,1200); INSERT…

Q: Write a query that Balance of each CUSTOMER who have made purchase(s) before AND subtotal that each…

A: Sql which means structured query languages and it is a domain-specific language used in programming…

Q: Q3: How many unique titles do we have in the employee table? Hint: You need to create TWO queries,…

A: 1) SELECT DISTINCT titles FROM EMPLOYEE

Q: Create the following table in your database with the following schema: Table: Products I Column Name…

A: Create table syntax : CREATE TABLE TABLE_NAME( column_name data_type, column_name data_type,…

Q: Write a query to display all vendors sorted by vendor name. Write a query to display the product…

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

Q: Write all the sql code (including create, insert and select)

A: in the following section we will be writing the queries based on information provided in the above…

Q: The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all…

A: Answer

Q: Create the following tables in your database with the following schema: Table: Countries | Column…

A: We need to write code of create table and insert table only.

Concept explainers

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.

Question

100%

Consider an Animal table with the following columns:
• ID - integer, auto increment, primary key
•
Name variable-length string
• Breed - variable-length string, must be one of the following:
•
Holsteiner, Paint, Saddlebred
Height decimal number, must be ≥ 10.0 and ≤ 20.0
-
• Birth Date - date, must be > Jan 1, 2010
Write the SQL Query to make the following updates:
1. Change the name to Luck and birth date to May 1, 2015 for animal
with ID 2.
2. Change every breed to NULL for animal born on or after December 20,
2015.
3. Delete all rows for animals born before March 13, 2013.

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: Describe Concept

VIEW

Step 2: Writing SQL queries to make specified updates

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

SQL ( ORACLE SQL DEVELOPER ) : THIS IS FIRST , SECOND AND THIRD TABLE for the Task 1 to solve : create table author_45( auth_name char(50), gender char(1), age number(3), nationality char(50), PRIMARY KEY (auth_name) ); create table book_45( isbn number(10), title char(50), ver_no number(2), publisher char(50), PRIMARY KEY (isbn) ); create table writtenBy_45( isbn number(10), auth_name char(50), yr_published number(4), price number(3), no_copy number(4), PRIMARY KEY (isbn,auth_name), foreign key (isbn) references book_45, foreign key (auth_name) references author_45 ); insert into author_45 values ('Benoit','F',42,'French'); insert into author_ 45 values ('Antonini','M',33,'Italian'); insert into author_ 45 values ('McAven','F',31,'Australian'); insert into author_ 45 values ('Williams','M',90,'British'); insert into book_45 values (101,'atabases',1,'Possum'); insert into book_45 values (202,'SQL Primer',2,'Hall'); insert into book_45 values…
Write a query in SQL code for: "List the book categories and the average book price of each category." Tablename is "BOOKS" and column names are: ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY
Write SQL CODE List the Professor's First (EMP_FNAME) and Last names (EMP_LNAME) of those who teach more than 2 classes (CLASS table). Use Noncorrelated Subquery with INNER JOIN.
Write an SQL query using a Wildcard operator that will show any ISBNstarting with 995 in the Books table. This query must also show the ISBNand the book title only.
HW2: Basic SQL 1. Write a query that will show all probation officers 2. Write a query that will show the first and last names of probation officers 3. Now write a query that shows first and last name of probation officers. Include the field prob_id but rename prob_id to probation officer ID. 4. Write a query that will show crime id, and the total charges for each crime ID. Include an alias for the total charges column called Total Charges. 5. Write a query that will concat the last and first names of criminals into one column. Add a space and comma between the last and first name of criminals. Give the column the alias Criminal Name. 6. List the last name and first name of all authors in only 1 column. Add a comma to separate the two names. 7. Run a query that will return the order#, item#, isbn, quantity, paideach. Include in the query a arithmetic operation that will total quantity and paideach. Alias the virtual column so it is labeled Item Total
You have a table named student having attributes student_name, id, batch, contact. Write a SQL query to display the names of all students in alphabetically increasing order.
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