SQL Essential Queries

SQL Essential Queries

• Find number of rows between two dates

  SELECT COUNT(customer_id) FROM customer_table where created_at BETWEEN '2021-01-07 00:00:00' AND '2021-01-14 00:00:00';
  

• List all columns of a table

  show columns from customer_table
  

• Get all tables

  show tables
  

• Get table schema

  show create table customer_table;