Provide the SQL statement. You only want to display only cus…
Provide the SQL statement. You only want to display only customers that are located in Michigan, Texas and Montana and have purchased more than $2,000.00 a year from your online store. Displays only the first and last name, email address and order by total spent in descending order. You did not create the table. The actual field names in the Customers table are: FirstName, LastName, Address, City, State, Zip Code, TotalSpent. TotalSpent is a decimal value in the table and the other values are nvarchar. The customerID is the primary key value and an int data type. Use proper coding style.
Read Details