With the information given, how do you create the following SQL Statements? CREA

Question

With the information given, how do you create the following SQL Statements? CREATE query for the customer table; INSERT new customer; INSERT house for sale; UPDATE customer; UPDATE house for sale asking price (Decrease asking price by $10,000); Provide a query that will identify which house a particular customer viewed; Provide a query that will give a list of all customers that are interested in buying a home; Provide a query that list all houses for sale; Provide a query that list all houses for sale (MLS#, asking price and Customer ID) with customer name, and phone number; Provide a query that list all houses for sale (MLS#) and the number of days on the market; Provide a query that list of customers (name, customer ID, and date of application) along with the MLS#, address, number of viewings that viewed a particular house.

Explanation / Answer

//query for customer table//

CREATE TABLE Customer(
CustomerName varchar(255),

PRIMARY KEY(CustId),

intrested int);

//query to insert a new customer //
INSERT INTO Customer(CustomerName,CustId,intrested)

VALUES("anyname",271298,0)

)

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.