Meta tags:
description= Adding SQL Concepts & problems which i solved day to day in this repo - shreyashji/SQL-Problem-Solving-learning;
Headings (most frequently used words):
navigation, about, footer, topics, stars, watchers, forks, menu, repository, latest, commit, history, folders, and, files, releases, packages, contributors, languages,
Text of the page (most frequently used words):
sql (266), and (52), how (50), find (42), with (40), for (25), the (22), question (20), all (16), data (16), #problem (15), leetcode (14), employees (14), github (13), interview (12), joins (12), calculate (12), salary (12), from (12), window (11), between (10), case (10), based (10), than (10), functions (10), date (9), day (8), top (8), rows (8), difference (8), rank (8), scenario (8), consecutive (8), most (8), highest (8), average (8), first (8), last (8), month (8), columns (8), string (8), you (6), amazon (6), group (6), multiple (6), queries (6), maximum (6), tranamt (6), same (6), having (6), replace (6), number (6), values (6), join (6), records (6), department (6), more (6), translate (6), table (6), year (6), sum (6), sales (6), function (6), datediff (6), convert (6), your (6), code (6), security (5), repository (5), one (5), solving (5), customer (5), analysis (5), this (4), status (4), forks (4), stars (4), activity (4), practice (4), sorting (4), analyst (4), where (4), cases (4), complex (4), questions (4), each (4), others (4), order (4), clause (4), generate (4), match (4), list (4), row (4), other (4), advance (4), study (4), tricky (4), duplicates (4), using (4), product (4), companies (4), employee (4), asked (4), alphanumeric (4), greater (4), less (4), dept (4), any (4), totals (4), methods (4), running (4), previous (4), salaries (4), days (4), identify (4), months (4), pivot (4), into (4), cte (4), expression (4), null (4), hard (4), lead (4), lag (4), signed (4), support (4), copilot (4), that (3), navigation (3), adding (3), concepts (3), problems (3), which (3), solved (3), repo (3), about (3), change (3), master (3), company (3), what (3), commit (3), actions (3), learning (3), quality (3), another (3), tab (3), refresh (3), session (3), reload (3), sign (3), developers (3), changelog (3), enterprise (3), grade (3), features (3), build (3), community (2), footer (2), report (2), watching (2), watchers (2), ssms (2), server (2), mysql (2), cpp (2), topics (2), files (2), happiness (2), index (2), india (2), google (2), position (2), cities (2), covid (2), increasing (2), continuously (2), user (2), has (2), display (2), these (2), fields (2), along (2), custid (2), ratio (2), transaction (2), experienced (2), top_10_sql_interview_questions_and (2), answers_frequently_asked_sql_interview_questions (2), sort (2), country (2), always (2), ascending (2), custom (2), students (2), marks (2), physics (2), chemistry (2), deadly (2), combination (2), commas (2), single (2), comma (2), finding (2), missing (2), quater (2), schedule (2), countries (2), dense (2), tie (2), breaking (2), empty (2), seats (2), take (2), home (2), assignment (2), startup (2), spotify (2), simple (2), only (2), scd (2), type (2), concept (2), interviews (2), second (2), recent (2), mode (2), frequent (2), value (2), column (2), retention (2), churn (2), part (2), nulls (2), diff (2), after (2), types (2), energy (2), consumption (2), cross (2), use (2), performance (2), new (2), repeat (2), customers (2), cost (2), orders (2), yelp (2), cool (2), votes (2), prime (2), subscription (2), rate (2), logic (2), delete (2), production (2), environment (2), check (2), their (2), managers (2), but (2), first_value (2), last_value (2), ytd (2), mtd (2), calendar (2), query (2), leap (2), cumulative (2), levels (2), manager (2), hierarchy (2), recursion (2), emails (2), domain (2), compare (2), monthly (2), remaining (2), week (2), gaps (2), least (2), countstar (2), count1 (2), countcolname (2), strings (2), lower (2), characters (2), insensitive (2), collate (2), extract (2), numbers (2), alphabets (2), names (2), startend (2), examples (2), like (2), pattern (2), matching (2), count (2), occurrence (2), character (2), overlapping (2), ranges (2), retiring (2), end (2), dateadd (2), eomonth (2), capitalize (2), letter (2), hired (2), dynamic (2), dynamically (2), unpivot (2), increment (2), who (2), have (2), years (2), organization (2), remove (2), leading (2), trailing (2), zeroes (2), decimal (2), science (2), recommendation (2), system (2), sqls (2), without (2), creating (2), tables (2), database (2), recursive (2), write (2), cte_sql (2), clause_common (2), lettcode (2), working (2), handling (2), self_join_concept_employee_salary_more_than_manager (2), s_salary (2), market (2), tournament (2), winners (2), median (2), tutorial (2), stuff (2), substring (2), trips (2), users (2), when (2), statement (2), weekdays (2), two (2), dates (2), exclude (2), weekends (2), datename (2), matches_won_loss_of_match (2), charnindex (2), splitstring (2), sql_interview (2), analytical (2), solve_15_sql_querries (2), common (2), example (2), clauses (2), 2nd (2), pareto (2), principle (2), implementation (2), total (2), rolling (2), avg (2), min (2), max (2), windowingfunction (2), dense_rank (2), row_number (2), sql_interview_question_y (2), txt (2), july2022 (2), some (2), would (2), definitely (2), below (2), message (2), name (2), commits (2), latest (2), menu (2), must (2), star (2), settings (2), insights (2), projects (2), shreyashji (2), universe (2), training (2), integrations (2), stories (2), center (2), documentation (2), learn (2), business (2), fixes (2), products (2), secret (2), can, perform, action, time, not, share, personal, information, manage, cookies, contact, docs, privacy, terms, 2026, inc, languages, contributors, packages, releases, view, folders, history, open, file, tags, branches, fork, notification, notifications, public, items, pull, requests, issues, dismiss, alert, switched, accounts, out, appearance, search, pricing, event, talks, workshops, next, partners, forum, events, webinars, blog, resource, connect, resources, premium, advanced, add, ons, trust, why, evaluate, see, industries, government, manufacturing, financial, services, healthcare, industry, nonprofits, startups, team, enterprises, stage, businesses, source, improvements, across, place, developer, articles, sponsors, trending, repos, explore, customize, certifications, scanning, leak, prevention, protection, vulnerability, detection, remediation, secure, cloud, development, environments, codespaces, enforcement, automation, ship, coding, agent, tasks, automated, work, hosting, review, collaboration, platform, skip, content,
Text of the page (random words):
github shreyashji sql problem solving learning adding sql concepts problems which i solved day to day in this repo github skip to content navigation menu sign in products platform github repository hosting code review and collaboration copilot ai coding agent for tasks projects and automated work build ship actions ci cd and automation code quality quality analysis fixes and enforcement codespaces cloud development environments secure code security vulnerability detection and remediation secret protection secret scanning and leak prevention all features developers learn documentation training certifications build build with copilot customize copilot integrations explore trending repos github sponsors developer articles changelog changelog your source for the latest features improvements and fixes across github products all in one place businesses by stage enterprises team startups nonprofits by industry healthcare financial services manufacturing government see all industries evaluate github why github customer stories business insights trust center add ons github advanced security enterprise grade code security copilot for business enterprise grade ai features premium support enterprise grade 24 7 support resources learn connect documentation resource center blog events webinars community forum customer stories integrations support customer support training github status company about partners changelog github universe github universe the event for developers by developers talks workshops and what s next for github pricing search sign in sign up appearance settings you signed in with another tab or window reload to refresh your session you signed out in another tab or window reload to refresh your session you switched accounts on another tab or window reload to refresh your session dismiss alert message shreyashji sql problem solving learning repository navigation code issues pull requests actions projects security and quality insights more items sql problem solving learning public notifications you must be signed in to change notification settings fork 16 16 star 10 10 you must be signed in to star a repository about adding sql concepts problems which i solved day to day in this repo topics leetcode leetcode cpp leetcode practice leetcode sql mysql sql sql server ssms activity stars 10 stars watchers 2 watching forks 16 forks report repository master branches tags go to file code open more actions menu latest commit history 83 commits 83 commits folders and files name name last commit message last commit date em em sql interview some of the questions would be definitely from below list sql interview some of the questions would be definitely from below list july2022 sql july2022 sql 1 1 sql_interview_question_y txt 1 1 sql_interview_question_y txt 1 windowingfunction rank dense_rank row_number sql 1 windowingfunction rank dense_rank row_number sql 10 sql running total advance sql rolling n months sum avg min max sql 10 sql running total advance sql rolling n months sum avg min max sql 11 ak pareto principle implementation in sql sql 11 ak pareto principle implementation in sql sql 11 find 2nd highest salary sql 11 find 2nd highest salary sql 12 ak scenario based on join group by and having clauses sql 12 ak scenario based on join group by and having clauses sql 13 cte common table expression example sql 13 cte common table expression example sql 14 solve_15_sql_querries sql 14 solve_15_sql_querries sql 15 lead lag window analytical functions in sql sql 15 lead lag window analytical functions in sql sql 16 sql_interview sql 16 sql_interview sql 17 difference between where and having clause in sql sql 17 difference between where and having clause in sql sql 18 lead lag window function sql 18 lead lag window function sql 19 charnindex splitstring function in sql sql 19 charnindex splitstring function in sql sql 2 ak matches_won_loss_of_match sql 2 ak matches_won_loss_of_match sql 20 calculate number of weekdays between two dates exclude weekends datediff datename sql 20 calculate number of weekdays between two dates exclude weekends datediff datename sql 21 case when statement in sql sql 21 case when statement in sql sql 22 ak leetcode hard problem complex sql 7 trips and users sql 22 ak leetcode hard problem complex sql 7 trips and users sql 23 replace stuff substring and translate sql string functions sql 23 replace stuff substring and translate sql string functions sql 24 sql joins tutorial using a case study sql 24 sql joins tutorial using a case study sql 25 methods to calculate median with sql sql 25 methods to calculate median with sql sql 26 ak tournament winners problem sql 26 ak tournament winners problem sql 27 ak leetcode hard problem 3 market analysis 2 sql 27 ak leetcode hard problem 3 market analysis 2 sql 28 ak tricky sql question sql 28 ak tricky sql question sql 29 leetcode 5 question sql 29 leetcode 5 question sql 3 self_join_concept_employee_salary_more_than_manager s_salary sql 3 self_join_concept_employee_salary_more_than_manager s_salary sql 30 working with sql null values null handling functions sql 30 working with sql null values null handling functions sql 31 ak lettcode problem sql 31 ak lettcode problem sql 32 how to write sql with cte_sql with clause_common table expression sql 32 how to write sql with cte_sql with clause_common table expression sql 33 recursive cte sql 33 recursive cte sql 34 practice sqls without creating tables in your database sql 34 practice sqls without creating tables in your database sql 35 data science sql interview question recommendation system sql 35 data science sql interview question recommendation system sql 36 1 remove leading and trailing zeroes from a decimal sql 36 1 remove leading and trailing zeroes from a decimal sql 36 10 how to increment salaries of employees who have 2 years with the organization datediff sql 36 10 how to increment salaries of employees who have 2 years with the organization datediff sql 36 11 unpivot convert data from columns into rows sql 36 11 unpivot convert data from columns into rows sql 36 12 pivot convert data from rows to columns sql 36 12 pivot convert data from rows to columns sql 36 13 dynamic pivot how to dynamically convert rows into columns sql 36 13 dynamic pivot how to dynamically convert rows into columns sql 36 14 how to find employees hired in last n months datediff sql 36 14 how to find employees hired in last n months datediff sql 36 15 how to capitalize first letter of a string sql 36 15 how to capitalize first letter of a string sql 36 16 how to find employees retiring at the end of the month dateadd eomonth sql 36 16 how to find employees retiring at the end of the month dateadd eomonth sql 36 17 how to identify overlapping date ranges sql 36 17 how to identify overlapping date ranges sql 36 18 count the occurrence of a character in a string sql 36 18 count the occurrence of a character in a string sql 36 19 find names that startend with more examples like pattern matching sql 36 19 find names that startend with more examples like pattern matching sql 36 2 how to extract numbers and alphabets from an alphanumeric string translate function sql 36 2 how to extract numbers and alphabets from an alphanumeric string translate function sql 36 20 how to find strings with lower case characters case insensitive collate sql 36 20 how to find strings with lower case characters case insensitive collate sql 36 21 difference between countstar count1 countcolname sql 36 21 difference between countstar count1 countcolname sql 36 22 how to find maximum of multiple columns sql 36 22 how to find maximum of multiple columns sql 36 23 how to find n consecutive date records sales for at least n consecutive days sql 36 23 how to find n consecutive date records sales for at least n consecutive days sql 36 24 no sales for n consecutive days identify date gaps sql 36 24 no sales for n consecutive days identify date gaps sql 36 25 how to find first and last day of week sql 36 25 how to find first and last day of week sql 36 26 how to find top n salaries in a department and sum the remaining as others sql 36 26 how to find top n salaries in a department and sum the remaining as others sql 36 27 compare monthly sales with previous month same month previous year first month of year sql 36 27 compare monthly sales with previous month same month previous year first month of year sql 36 28 how to find number of emails from the same domain sql 36 28 how to find number of emails from the same domain sql 36 29 how to find all levels of employee manager hierarchy recursion sql 36 29 how to find all levels of employee manager hierarchy recursion sql 36 3 how to calculate running totals and cumulative sum sql 36 3 how to calculate running totals and cumulative sum sql 36 30 sql query to find a leap year 2 methods sql 36 30 sql query to find a leap year 2 methods sql 36 31 how to generate date records for a calendar table sql 36 31 how to generate date records for a calendar table sql 36 32 what is the difference between translate and replace sql 36 32 what is the difference between translate and replace sql 36 4 how to calculate ytd and mtd totals window functions sql 36 4 how to calculate ytd and mtd totals window functions sql 36 5 how to calculate the first and last order first_value last_value window functions sql 36 5 how to calculate the first and last order first_value last_value window functions sql 36 6 find employees with salary less than dept average but more than average of any other dept any sql 36 6 find employees with salary less than dept average but more than average of any other dept any sql 36 7 how to find employees with highest salary in a department sql 36 7 how to find employees with highest salary in a department sql 36 8 find employees with salary greater than department average and less than company average sql 36 8 find employees with salary greater than department average and less than company average sql 36 9 how to find employees with salary greater than their managers salary sql 36 9 how to find employees with salary greater than their managers salary sql 36 check for alphanumeric values sql 36 check for alphanumeric values sql 37 ak how to delete duplicates in production environment sql 37 ak how to delete duplicates in production environment sql 38 amazon prime subscription rate sql logic sql 38 amazon prime subscription rate sql logic sql 39 1 yelp top cool votes problem sql 39 1 yelp top cool votes problem sql 39 amazon problem highest cost orders sql 39 amazon problem highest cost orders sql 4 ak find new and repeat customers sql 4 ak find new and repeat customers sql 40 ak sql cross join use cases master data performance data sql 40 ak sql cross join use cases master data performance data sql 41 cs highest energy consumption sql 41 cs highest energy consumption sql 42 ak most asked sql join based interview question no of records after 4 types of joins sql 42 ak most asked sql join based interview question no of records after 4 types of joins sql 43 ak all joins most asked question sql 43 ak all joins most asked question sql 44 ak all joins with diff values sql 44 ak all joins with diff values sql 45 ak all joins with nulls sql 45 ak all joins with nulls sql 46 ak customer retention and churn analysis part 1 sql interview question product based companies sql 46 ak customer retention and churn analysis part 1 sql interview question product based companies sql 47 ak how to calculate mode in sql how to find most frequent value in a column sql 47 ak how to calculate mode in sql how to find most frequent value in a column sql 48 ak second most recent activity sql sql 48 ak second most recent activity sql sql 49 ak find the change in employee status sql 49 ak find the change in employee status sql 5 ak scenario based interviews question for product companies sql 5 ak scenario based interviews question for product companies sql 50 ak scenario based sql question solving using scd type 2 concept sql 50 ak scenario based sql question solving using scd type 2 concept sql 51 ak a simple and tricky sql question rank only duplicates sql 51 ak a simple and tricky sql question rank only duplicates sql 52 ak data analyst take home assignment by a startup spotify case study sql 52 ak data analyst take home assignment by a startup spotify case study sql 53 ak advance sql queries consecutive empty seats sql 53 ak advance sql queries consecutive empty seats sql 56 difference between row number rank and dense rank tie breaking scenario sql 56 difference between row number rank and dense rank tie breaking scenario sql 57 how to generate match schedule for list of countries match one row with all other rows sql 57 how to generate match schedule for list of countries match one row with all other rows sql 58 ak finding missing quater sql 58 ak finding missing quater sql 58 replace multiple commas with a single comma sql 58 replace multiple commas with a single comma sql 59 ak find students with same marks in physics chemistry deadly combination of group by and having clause in sql sql 59 ak find students with same marks in physics chemistry deadly combination of group by and having clause in sql sql 59 sort by one country always at top and others in ascending order custom sorting sql 59 sort by one country always at top and others in ascending order custom sorting sql 6 top_10_sql_interview_questions_and answers_frequently_asked_sql_interview_questions sql 6 top_10_sql_interview_questions_and answers_frequently_asked_sql_interview_questions sql 60 sql queries for experienced sql 60 sql queries for experienced sql 61 user has to display all these fields along with maximum tranamt for each custid and ratio of tranamt and maximum tranamt for each transaction sql 61 user has to display all these fields along with maximum tranamt for each custid and ratio of tranamt and maximum tranamt for each transaction sql 62 1 amazon complex sql interview questions group by joins or multiple queries sql 62 1 amazon complex sql interview questions group by joins or multiple queries sql 63 ak find cities where covid cases increasing continuously sql 63 ak find cities where covid cases increasing continuously sql 64 ak google sql interview question for data analyst position sql 64 ak google sql interview question for data analyst position sql 65 ak sorting happiness index data with india on top sql 65 ak sorting happiness index data with india on top sql view all files about adding sql concepts problems which i solved day to day in this repo topics leetcode leetcode cpp leetcode practice leetcode sql mysql sql sql server ssms activity stars 10 stars watchers 2 watching forks 16 forks report repository releases packages contributors languages footer 2026 github inc footer navigation terms privacy security status community docs contact manage cookies do not share my personal information you can t perform that action at this time
|