How to sort data using SQL query |SQL Tutorial for beginners | Learn to write query to analyse data
Sorting is one of the important operations, while using SQL Queries.
Through this video the viewer would be able to understand how to use sorting in both Excel and SQL. The viewer would also learn about using multi-level sorting.
Most importantly, there is a realtime application of a data set to solve a problem statement. i.e Finding the best cricket captain using SQL queries and analysing a dataset .
The dataset has been taken from the link:
https://stats.espncricinfo.com/ci/eng...
The query used in the analysis is :
SELECT
player, matches, won, lost, winning_percent
FROM
captains
ORDER BY matches DESC , 5 DESC;
In case you want to learn how to create this table you can refer to the Video:
• Creating a table in SQL. Use Excel da...
This video will be helpful for beginners in the world of analytics ie data analyst, business analysts, Jr Data scientists
#learnSQl #sqldataanalysis #exceltipsandtricks, #dhoni,#MSExcel #interviewprep #Sorting #analytics, #TSQL
#analyst #analysis #dataanalysis #Cricket #Captain #CricketCaptain
#bestcaptain #Mysql #my-sql
tags: sql for beginners, sql tutorial for beginners, sql interview questions and answers, sql for beginners, sql tutorial, Excel, MS-EXCEL, SQL, MY SQL, T-SQL, SQL query, SQL tutorial, SQL for beginners, create table in SQL, SQL server, SQL database, datascience, data analytics, business analytics, Excel tips, SQL tips, SQL interview questions, SQL interview preparation, SQL hacks, Excel to SQL, sorting data using SQL
