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 role of the database administrator in the development, implementation and maintenance of a database system.
Before adding information into a database, it is necessary to collect it and sort it into relevant categories.
Explain how a repository affects computer system development.
Differentiate between database management systems and file-oriented systems.
Differentiate between database management systems and file-oriented systems.
Database Administrators and Server Administrators both have responsibilities for backing up data.
DDL is a language used to define the structure of data.
What does it mean to maintain a database?
large scale database
Describe the roles of Database Administrators (DBAs) in the context of database development.