Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Quiz 2 CLO 4 Marks 10 Consider the following customer table and write SQL queries. (Queries should be hand written on paper) Customer CustNo CustFirstName

image text in transcribed

Quiz 2 CLO 4 Marks 10 Consider the following customer table and write SQL queries. (Queries should be hand written on paper) Customer CustNo CustFirstName CustLastName CustStreet CustCity CustState CustZip Custa! 1. List the customer number, the name (first and last), the city, and the balance of customers who reside in Denver with a balance greater than $ 150 or who reside in Seattle with a balance greater than $300. 2. List the average balance of customers by city. Include only customers residing in Washington State (WA). 3. List the average balance and number of customers by city. Only include customers ding in Washington State (WA). Eliminate cities in the result with less than two customers. 4. Increase the balance of customers by 10 percent whose name containing the word 'Ali'in first name 5. Delete the rows from customer tables for those customers who reside in Seattle with a balance greater than $300

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DNA Databases

Authors: Stefan Kiesbye

1st Edition

0737758910, 978-0737758917

More Books

Students also viewed these Databases questions