You should run the DROP CONSTRAINT query before running the ALTER TABLE query

SELECT * FROM students WHERE enrollment_date >= ‘2020-06-01’ OR academic_status = ‘Graduated’ AND graduation_date >= ‘2020-01-01’ ORDER BY enrollment_date DESC

4

DELETE FROM Customer WHERE CustomerID = 12345

SELECT EmployeeName FROM Employee WHERE EmployeeName = ‘Jack Smith’;

SELECT ItemName, Price FROM Products WHERE ItemDescription LIKE ‘%chocolate%’;

CREATE TABLE Order (OrderID INTEGER, OrderItemID INTEGER, PRIMARY KEY (OrderID, OrderItemID))

False

True

True

Decimal

UPDATE LoanedBooks SET Books = 0 WHERE (NAME = ‘Harry’ AND City = ‘San Francisco’)

SELECT COUNT(*) FROM Employee

SUM(Points), WHERE, GROUP BY, PlayerID

Foreign key

CREATE VIEW [dbo].[NorthAmericanMammals_View], AS SELECT a.Id, a.Name, FROM Animal a

Empty

INTERSECT

Improve performance

Exclude duplicate rows, Exclude repeating groups

Full join

TOP 10, IS NOT NULL, ORDER BY

VARCHAR, INT, DECIMAL

UPDATE Product SET ProductCategory = 43 WHERE ProductDescription = ‘spoon’

compositional

cartesian product

CREATE TABLE Employee (EmployeeID INTEGER PRIMARY KEY)

PRIMARY KEY, CONSTRAINT

DELETE FROM Volunteer WHERE GivenName = ‘Tia’

In the order in which the rows were inserted.

PhoneNumber, IS NOT NULL, ORDER BY

SELECT COUNT(ID), AVG(UnitPrice+Quantity), MAX(UnitPrice+Quantity), SUM(UnitPrice+Quantity) FROM ItemsOnOrder GROUP BY ItemNumber, LineItemTotal

INSERT INTO EmployeeCopy SELECT * FROM Employee

No rows will be deleted from the table

SELECT COUNT(OrderID), Country FROM Orders GROUP BY Country HAVING COUNT(orderID) < 50

A new row in the table

cascade delete

UPDATE Products SET Price = Price * 1.06 WHERE ItemNumber = 1;

True

False

False

True

DELETE FROM Employee WHERE Phone IS NULL

SELECT * FROM Orders WHERE NOT ship_state = ‘TX’ AND NOT ship_state = ‘AZ’

ALTER TABLE Customers DROP COLUMN SSN;

Remove the ORDER BY clause

DROP VIEW EmployeeView

ALTER TABLE

A foreign key

A non-clustered index on the Category column

LIKE

The plus (+) operator cannot be used to append character data

ChapterID, LanguageID

A constraint

CREATE VIEW MyGame AS SELECT Name FROM Games ORDER BY Name

REVOKE SELECT ON Customer FROM User1

CREATE TABLE Student ( ID INT, Name VARCHAR (100), Age INT)

AND, >, ORDER BY, ArrivalTime DESC

Return large results sets, are accessed randomly