SQL Tutorial for Beginners | Number of shipments for each city on each date | #barclays

SQL Tutorial for Beginners | Number of shipments for each city on each date | #barclays Use below scripts for the video: create table shipments( shipmentid int, shipment_date date, city varchar(30) ) insert into shipments values(101,'2026-01-10','Mumbai'); insert into shipments values(101,'2026-01-11','Mumbai'); insert into shipments values(102,'2026-02-02','Delhi'); insert into shipments values(102,'2026-02-02','Delhi'); insert into shipments values(102,'2026-02-03','Chennai'); insert into shipments values(103,'2023-04-15','Kanpur'); insert into shipments values(103,'2026-04-16','Kanpur'); insert into shipments values(104,'2026-03-01','Chennai'); insert into shipments values(105,'2026-03-02','Chennai'); insert into shipments values(106,'2026-03-02','Kanpur'); insert into shipments values(107,'2026-04-15','Kanpur'); insert into shipments values(108,'2026-02-02','Chennai'); insert into shipments values(109,'2026-02-02','Chennai'); insert into shipments values(110,'2026-05-15','Pune'); insert into shipments values(111,'2026-05-16','Pune'); insert into shipments values(111,'2026-05-16','Pune'); insert into shipments values(112,'2026-05-18','Pune'); insert into shipments values(112,'2026-05-18','Mumbai'); What you'll learn: SQL for Beginners Advanced SQL Queries Joins (INNER, LEFT, RIGHT, FULL) GROUP BY & HAVING Window Functions CTE (Common Table Expressions) Stored Procedures Views, Indexes & Triggers Aggregate & Scalar Functions Subqueries & Correlated Queries SQL Performance Optimization SQL Interview Questions & Answers MySQL Tutorials PostgreSQL Tutorials Microsoft SQL Server Tutorials Oracle SQL Basics Database Design Concepts Real-Time SQL Projects Data Analytics using SQL #sqlserver Tutorial #learnsql #sqlforbeginners #advancedsql #sqlinterviewquestions #sqlqueries #databasetutorial #SQL Server Tutorial #databasemanagement #sqljoins #innerjoin #leftjoin #rightjoin #FULLJOIN #groupby #HAVINGClause #windowfunctions #CTESQL #StoredProcedures #Views in SQL #Indexes in SQL #Triggers in SQL #SQL Functions #AggregateFunctions #Subqueries #CorrelatedSubquery #SQL Practice #SQLExamples #dataanalytics #DataAnalystSQL #sqlcourse #sqltraining #SQLExplained #cisco #ciscosystems #maang #faang #leetcode #pivot_table #pivot #barclays #citibank #ubs