Top Sql Interview Questions | SQL Advanced Questions | Ashutosh Kumar

Подписаться 18 тыс.

Просмотров 2,6 тыс.

50% 1

Sql one of the most important language asked in most of the analytics interviews, in this i will be solving sql questions which was asked to me in one of the company.
Dataset - github.com/ashutoshkr103/Micr...
👉 Complete playlist on Advanced Sql
• Advanced Sql Concepts
👉 Complete playlist on Sql Interview questions and answers
• HackerRank SQL problem...
---------------------------------------------------------------------------------------------------------------------
Check out some more relevant content here
👉 How to Learn SQL
• How to learn sql for b...
👉 How to become a business analyst complete roadmap-
• Business Analyst Compl...
👉 How to become a data analyst complete roadmap-
• Data Analyst Complete ...
👉 Top 3 you tube channels to learn sql for free for beginners
• Video
👉 Rank ,Dense Rank, Row Number in sql -
• RANK - DENSE RANK - RO...
👉 Cross join in sql
• CROSS JOIN SQL
👉 union join in sql
• UNION IN SQL
👉 left join in sql
• LEFT JOIN IN SQL
👉 Right join in sql
• RIGHT JOIN IN SQL
👉 Inner join in sql
• INNER JOIN IN SQL
👉 Introduction to tables and databases in sql -
• INTRO TO TABLES AND DA...
👉 Aggregate Function in sql
• AGGREGATE FUNCTION IN SQL
👉 Functions in sql-
• IMPORTANT FUNCTIONS IN...
👉 String Function in sql
• STRING FUNCTIONS IN SQL
👉 CRUD operations in sql
• CREATE- READ- UPDATE-D...
👉 Autoincrement in sql
• Auto Increment in SQL ...
👉 Primary Key in sql-
• PRIMARY KEYS IN SQL - SQL
👉 Null and Default values in sql-
• NULL AND DEFAULT VALUE...
👉 Data types in sql-
• Data types in Sql - SQL
____________________________________________________________________
Fill the form below to subscribe yourself to the analytics jobs mailing list to receive regular job opening updates - docs.google.com/forms/d/e/1FA...
Why you should definitely fill the analytics job updates google form - • Job Openings into busi...
_______________________________________________________________________
Connect with me
📸Instagram - / ashutosh.analytics
💻Linkedin- / ashutoszh
_____________________________________________________________________
Comment down if you have any doubts
Please leave a LIKE 👍 and SUBSCRIBE ❤️ to my channel to receive more amazing content in data analytics and data science.
_____________________________________________________________________
🏷️ Tags
sql,
sql for data science,
sql for data analytics,
sql practise questions,
sql practise questions and solutions,
sql tutorials for beginners,
sql problems for data engineers,
ashutosh,
ashutosh kumar,
ashutosh kumar analytics,
sql problems easy,
sql problem medium,
sql problems hard,
sql window functions,
sql advanced questions,
rank functions in sql,
lag lead in sql,
sql interview questions and answers,
sql interview questions,
sql questions asked in interviews,
hackerrank sql solutions,
hackerearth sql solutions,
leetcode sql solution
🏷️HashTags
#sql #interviews #questions #solutions

Опубликовано:

15 сен 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 5

@AshutoshKumaryt Год назад

👉 SQL Portfolio Project Indian Census- Part 1 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-I3YvjFfn478.html 👉 Advanced Sql Concepts Complete Playlist ru-vid.com/group/PLbTF1OfX62c3RQ_ZFfyNBWVPdz_OWTMLG

@magibis7519 7 месяцев назад

Super

@hasanmougharbel8030 Год назад

Hello man, god bless your efforts. A have a general enquiry as a new sql learner. When i apply INSERT, UPDATE, or DELETE statement inside sql management studio, is the commit statement applied implicitly as part of the three former commands. The reason that i want to make sure that when these three commands being applied would take effect on the database directly and at same time for all users. Thanks for assisting me with my enquiry.

@perumalbalachandranjj2358 Год назад

Thanks for your video. I have solved in joins. Is it correct or not -- 1 write a query to get customer name, count of orders purchased in april'2021 and may'2021 select i.customer_name,i.customer_id,count(1),order_date from inquestion i left join inorder o on i.customer_id = o.customer_id where order_date between '4/1/2021' and '5/31/2021' group by customer_id order by order_id; -- 2 write a query to get customer names who bought in May'2021 and are from Jharkhand select i.customer_name, state,count(1) from inquestion i left join inorder o on i.customer_id = o.customer_id where order_date between '5/1/2021' and '5/31/2021' and state='Jharkhand' group by customer_name; -- 3 write a query to get customer name and their latest order information select i.customer_name, i.state,max(o.order_date) as latestorder,o.order_id,o.amount from inquestion i left join inorder o on i.customer_id = o.customer_id where order_id is not null group by customer_name; -- 4 write a query to get top 2 customer id and name based on total transaction value for each month select i.customer_name, i.state,o.customer_id,count(1), sum(o.amount) as totaltranscation from inquestion i left join inorder o on i.customer_id = o.customer_id group by customer_id order by totaltranscation desc limit 2;

@hasanmougharbel8030 Год назад