database_basic_query

Create a database and use the database

• Create a database named database_query
• Use database database_query
• Create a table named customers
• Insert data into customer table

Now i execute the following query

• Show only 2 members whose points are more than 1000.
• Find the customers whose age is in 1980 to 1990 or points less than 1000.
• Order the customers by points in ascending and descending order.
• Find the customer whose name contains 'burgh' using like and regexp.
• Find the customer who does not have phone number.
• Change the 'Date of Birth' column name into 'dob'.
• Find the max point holder customer.
• Execute a query for the following scenario.
• If customers have points less than 1000, they are bronze member.
• If customers have points more than 1000 and less than 2000, they are silver member.
• If customers have points more than 2000 and less than 3000, they are gold member.
• If customers have points more than 3000, they are platinum member.

To run this project just clone this sql file and open with SQLyog.