Answered step by step
Verified Expert Solution
Question
1 Approved Answer
7. Consider the CUSTOMERs table having the following records CUSTOMERS [Primary Key ID] AGE ADDRESS 25 Delhi 25 Mumbai NAME Ramesh SALARY 2000.00 1500.00 2000.00
7. Consider the CUSTOMERs table having the following records CUSTOMERS [Primary Key ID] AGE ADDRESS 25 Delhi 25 Mumbai NAME Ramesh SALARY 2000.00 1500.00 2000.00 6500.00 8500.00 4500.00 Ahmedabad 2 Khilan 3 Kaushik Kota 4 Chaitali 5 Hardik 6 Komal 7 Muffy 27 Bhopal 22 MP 24 Indore 10000.00 1a) Write a query which will change the ADDRESS and the SALARY for a customer whose ID number is 6 in the table. The new ADDRES is 'Wheeler' and the new SARY is 5500,0010 points) Insert into ADDRES3 7o) wira a quanr wilich
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started