Write SQL commands for following customer table: | CustomerID Cust_Name Age 101 Alex 35 102 James 28 103 Paul 30 104 Allene 32 105 Kate 29 Address Paris London Paris Rome Beijing Order_amount 200 340 440 566 225 1. Write a query to create a customer table containing above columns, whereas customer id as primary key. 2. Write a query to insert multiple records into customer table. 3. Write a query to list name of customers having age between 20 to 30. 4. Write a query to list name of customers who either belong to Paris, London or Beijing order by name and age. 5. Write a query to show list of customers whose name ends with character 'E'.

Write SQL commands for following customer table: | CustomerID Cust_Name Age 101 Alex 35 102 James 28 103 Paul 30 104 Allene 32 105 Kate 29 Address Paris London Paris Rome Beijing Order_amount 200 340 440 566 225 1. Write a query to create a customer table containing above columns, whereas customer id as primary key. 2. Write a query to insert multiple records into customer table. 3. Write a query to list name of customers having age between 20 to 30. 4. Write a query to list name of customers who either belong to Paris, London or Beijing order by name and age. 5. Write a query to show list of customers whose name ends with character 'E'.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Do you know how to enter user data into a database?
Explain the purpose and functionalities of database query languages such as SQL (Structured Query Language). Discuss the different types of SQL queries (SELECT, INSERT, UPDATE, DELETE) and their applications.
database defination
Database Administrators and Server Administrators both have responsibilities for backing up data.
Data hedling
Explanation it correctly and details Q)what is a schedule of values? why is it important
Databases use different keywords for searches than the web does. How are various queries answered and search terms used?
large scale database
SQL-formatting for a database named "Construct"?
Describe the roles of Database Administrators (DBAs) in the context of database development.