SQL Aggregate functions and Joins

 select count(*) from Customers;

select avg(age) from Customers;

select sum(age) from Customers;

select min(age) from Customers;

select max(age) from Customers;



select Customers.first_name,Customers.last_name,Orders.item,Orders.amount from Customers inner join Orders on Customers.customer_id=Orders.customer_id;


select Customers.first_name,Customers.last_name,Orders.item,Orders.amount from Customers left join Orders on Customers.customer_id=Orders.customer_id;


select Customers.first_name,Customers.last_name,Orders.item,Orders.amount from Customers right join Orders on Customers.customer_id=Orders.customer_id;


select Customers.first_name,Customers.last_name,Orders.item,Orders.amount from Customers full join Orders on Customers.customer_id=Orders.customer_id;

Comments

Post a Comment

Popular posts from this blog

Requests and Urllib

REQUESTS:- import requests # url="https://httpbin.org/post" # data={ #     "name":"hari", #     "age":21 # } # response=requests.post(url,data=data) # print(response.text) # response.status_code   # HTTP status code # response.text          # Response body as text # response.content       # Raw bytes # response.json()        # Convert JSON response to Python object # response.headers       # Response headers # GET REQUEST:- # url = "https://jsonplaceholder.typicode.com/posts/1" # response = requests.get(url) # print(response.text)  URLLIB:- import urllib . request import urllib . parse # link="https://jsonplaceholder.typicode.com/posts/2" # response=urllib.request.urlopen(link) # data=response.read() # print(data.decode("utf-8")) # print(data) # POST REQUEST:- # url="https://httpbin.org/post" # data={ #     "name":"Hari", #     "age":23 # } # encoded_data=urlli...
Read more

Python Time Zones

  from datetime import datetime from zoneinfo import ZoneInfo # UTC=Coordinated Universal Time date = datetime . now ( ZoneInfo ( "UTC" )) india_time = date . astimezone ( ZoneInfo ( "Asia/Kolkata" )) usa_time = datetime . now ( ZoneInfo ( "America/New_York" )) uk_time = datetime . now ( ZoneInfo ( "Europe/London" )) japan_time = datetime . now ( ZoneInfo ( "Asia/Tokyo" )) australia_time = datetime . now ( ZoneInfo ( "Australia/Sydney" )) germany_time = datetime . now ( ZoneInfo ( "Europe/Berlin" )) print ( usa_time ) print ( india_time ) print ( uk_time ) print ( japan_time ) print ( australia_time ) print ( germany_time ) # print(date)
Read more
  # pip install mysql-connector-python import sqlite3 conn = sqlite3 . connect ( "student.db" ) cur = conn . cursor () cur . execute (     """ CREATE TABLE IF NOT EXISTS students(     id INTEGER PRIMARY KEY,     name TEXT,     age INTEGER ) """ ) # cur.execute("INSERT INTO students(name, age) VALUES(?, ?)",("Gunjan", 21)) cur . execute ( "INSERT INTO students(name,age) values ('Gunjan',20)" ) conn . commit () cur . execute ( "SELECT * FROM students where age=20" ) rows = cur . fetchall () for r in rows :     print ( r ) # conn.commit()
Read more