Skip to content

salauddinalfaruq/basic-database-query

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

basic-database-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.

About

Create a database, insert some data and execute query.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published