CREATE TABLE IF NOT EXISTS mxsales( year integer, month integer, weekyear character…
- User
CREATE TABLE IF NOT EXISTS mx_sales( year integer, month integer, weekyear character varying(100) COLLATE pg_catalog."default", day integer, date date, salescategory character varying(100) COLLATE pg_catalog."default", channel character varying(100) COLLATE pg_catalog."default", priceband character varying(100) COLLATE pg_catalog."default", region character varying(100) COLLATE pg_catalog."default", productgroup character varying(100) COLLATE pg_catalog."default", segment character varying(100) COLLATE pg_catalog."default", model character varying(100) COLLATE pg_catalog."default", modelname character varying(100) COLLATE pg_catalog."default", selloutquantity integer, selloutamount bigint, sellinquantity integer, sellinamount bigint, price integer, familyname character varying(100) COLLATE pg_catalog."default"
); CREATE TABLE IF NOT EXISTS mx_dlb ( year INTEGER, -- year of sellout/sale, weekyear character varying(100) COLLATE pg_catalog."default",--weekyear of sellout, day integer, date date, month integer,--month of sellout counterselloutvalue double precision,-- value of sellout/amount counterselloutvolume double precision,-- volume of sellout region character varying(100) COLLATE pg_catalog."default",-- region of sale competitor character varying(100) COLLATE pg_catalog."default",--competitor/competition name priceband character varying(100) COLLATE pg_catalog."default",-- price bands of different model/modelcode sold channel character varying(100) COLLATE pg_catalog."default",-- channel through which it is sold segment character varying(100) COLLATE pg_catalog."default", modelname character varying(100) COLLATE pg_catalog."default",-- market name ); ###Examples: 1.What is competitor wise market share for month may and year 2024. Query : ------Using OVER()-------------------------------------------------------------- WITH monthly_sales AS ( SELECT competitor, year, month, SUM(counterSelloutValue) AS total_sales FROM mx_dlb WHERE year = 2024 AND month = 5 GROUP BY competitor, year, month ) SELECT competitor, ROUND(total_sales * 100.0 / SUM(total_sales) OVER (), 0) AS market_share_percent, '%' AS units_of_measurement FROM monthly_sales; -----Using CTE------------------------------------------------------------------ WITH cte AS ( SELECT competitor, SUM(counterselloutvalue) AS CV FROM mx_dlb WHERE year = 2024 AND month = 5 GROUP BY competitor ) SELECT competitor, ROUND(CV * 100.0 / (SELECT SUM(CV) FROM cte), 2) AS market_share, '%' FROM cte; 2. show me SAMSUNG market share for month may and year 2024. Query : WITH monthly_sales AS ( SELECT competitor, year, month, SUM(counterSelloutValue) AS total_sales FROM mx_dlb WHERE year = 2024 AND month = 5 GROUP BY competitor, year, month ) SELECT competitor, ROUND(total_sales * 100.0 / SUM(total_sales) OVER (), 0) AS market_share_percent, '%' AS units_of_measurement FROM monthly_sales WHERE competitor = 'Samsung'; 3.top 5 performing competitors by sellout value under GT/MT channel for month may and year 2024. Query : ----for all channels--------------------------------------------------------------- WITH monthly_sales AS ( SELECT competitor, year, month, SUM(counterSelloutValue) AS total_sales FROM mx_dlb WHERE year = 2024 AND month = 5 GROUP BY competitor, year, month ) SELECT competitor, ROUND(total_sales / 10000000, 0) AS total_sales_in_crores, 'cr' AS units_of_measurement FROM monthly_sales ORDER BY total_sales DESC LIMIT 5; 4.show me Samsung market share for above 40 k priceband for month may and year 2024. Query : select competitor,sum(counterselloutvalue)*100 / (Select sum(counterselloutvalue) from mx_dlb where year=2024 and month=5 and priceband='Above 40K' ) as marketshare from mx_dlb where year=2024 and month=5 and priceband='Above 40K' and competitor='Samsung' group by competitor; 5.show me Samsung sellout value priceband wise for month may and year 2024. Query : select priceband,sum(counterselloutvalue) as counterselloutvalue from mx_dlb where year=2024 and month=5 and competitor='Samsung' group by priceband 5. How much is the smart phone sales this month for North 1 region. Query: SELECT ROUND(SUM(selloutamount) / 10000000, 2) as total_amount_in_crores FROM mx_sales WHERE region = 'North 1' AND salescategory = 'Smart Phone' AND month = 6; ### Response: Based on your instructions, here is the SQL query I have generated to answer the question `{question}`:I have this database schema with some sample questions and their sql queries.I need to test a vendor on the basis of its ability to generate more complex analytics and data feteching related queries using the database schema mentioned above,Kindly generate 100 such questionss that can be asked from it
- Assistant
Sure, I'd be happy to help. Here are 100 sample questions that you can use to test a vendor's ability to generate complex SQL queries using the provided database schema:
Questions:
- What is the total sellout amount for each product group for the year 2023?
- Show the month-on-month sellout quantity trend for the model named "Galaxy S21" in 2024.
- Determine the weekly sales performance for each familyname in the North 1 region for quarter 1 of 2024.
- List the top 10 models by sellin quantity for the first half of 2023.
- Calculate the average price of all products sold in region 'West 2' for the year 2024 by month.
- What competitor had the highest sellout value in Q2 2024 in the GT channel?
- Determine the monthly growth rate in sellout amount for the segment 'Premium' in 2023.
- Show the regional distribution of sales for product group 'Tablets' for the year 2023.
- Calculate the YoY (Year over Year) growth in sellout quantity for the competitor 'Apple' in 2023.
- What is the average sellin amount for each region for 2024?
- Find the top 5 price bands by sellout volume for the month of January 2023.
- What is the total sellout amount for each channel in H2 (second half) of 2023?
- Show the top 3 models by sellout quantity for the GT channel in February 2024.
- Determine the sales share of each competitor for the price band '20K-30K' in 2023.
- Calculate the sum of sellout quantities per day for the whole year 2024.
- Find the month with the highest sellout value for the model 'iPhone 13 Pro' in 2024.
- Determine the average sellout amount for the region 'East 1' under the 'MT' channel by month in 2023.
- Compute the total sales for segment 'Economy' by quarter in 2024.
- Show the month-wise trend in sellin quantities for the modelnamed 'Pixel 6' in 2023.
- Compute the average counter sellout value for competitors per week for 2024.
- Determine the most popular segment by sellout quantity for model named 'Galaxy A52' in March 2024.
- Calculate the month-to-month change in sellout amounts for the channel 'Online' for H1 (first half) of 2023.
- Show the sellout volume for each day of the week for October 2023.
- Find the total sellout value for the region 'South 2' by salescategory for 2023.
- Determine the competitor with the least market share in the MT channel for August 2024.
- Calculate the quarterly sellout quantity growth for the priceband '10K-20K' for 2023.
- Determine the average daily sellout amount for each channel in December 2024.
- List the regions with the highest cumulative sellout value for the segment 'Mid-Range' in Q4 2023.
- Compute the average price for products sold in the region 'Central' by month in 2024.
- Find the top 5 models by sellout value for the price band '30K-40K' in Q1 2024.
- Show the day-of-week analysis for sellout volume for each channel in May 2024.
- Calculate the percentage contribution of each sales category in the sellout amount for June 2023.
- Find the total sellout amounts for each model by region for the year 2024.
- Determine the average counter sellout volume for the segment 'Premium' by month in 2023.
- Compute the monthly average competitor-wise market share for the 'West 1' region for 2024.
- Calculate the day-on-day growth rate in sellout amount for region 'North 2' in February 2024.
- Determine the model with the highest weekly sellout quantity in the 'GT' channel for H2 2023.
- Show the price-band wise distribution of sellout value for September 2024.
- Find the top 10 models by sellin amount for the 'East 2' region in 2023.
- Compute the total sellout quantity for the models under the 'Mid-Range' segment in Q3 2024.
- Analyze the month-on-month change in sellout amounts for the price band 'Above 50K' in 2023.
- Determine the total sellout value for the 'North 3' region by familyname for 2024.
- Calculate the average sellout quantity for each sales category in the 'MT' channel month-by-month in 2023.
- Show the top 5 regions by sellout value for the segment 'Mid-Range' for Q2 2024.
- Determine the highest selling model by sellin quantity in the 'Online' channel for 2023.
- List the monthly trends in sellout quantities for the 'Central' region for segment 'Premium' in 2024.
- Compute the total counter sellout value for the competitor 'Xiaomi' by quarter in 2023.
- Find the price bands contributing the most to the overall sellout value for Q3 2024.
- Determine the average weekly sellout quantity for the channel 'GT' for March 2023.
- Calculate the monthly sum of sellout amounts for the segment 'Economy' in 2024.
- Show the competitor wise breakdown of sellout quantities for the 'West 2' region in Q1 2024.
- What is the average counter sellout volume for the family name 'Galaxy' by year for 2023?
- Determine the month with the lowest sellout value for competitor 'Google' in the MT channel in 2024.
- Calculate the quarterly sellin amount for each product group in 2023.
- Find the model-wise contributions to total sellout value for the North 1 and South 1 regions in Q3 2023.
- Show the monthly trends in counter sellout value for the channel 'MT' in 2024.
- Determine the price band that contributed the most to the sellout volume for the 'East 1' region in Q2 2024.
- Compute the monthly growth in sellout quantities for the product group 'Wearables' in 2023.
- Calculate the competitor-wise quarterly counter sellout value for the 'West 1' region in 2024.
- Determine the model with the highest average price in the region 'Central 1' in 2023.
- Show the distribution of sellout value across each day of the week for January 2024.
- Analyze the month-wise sellout quantity for the 'GT' and 'MT' channels for the competitor 'Apple' in 2023.
- Find the top 5 family names by sellout amount in the 'North 2' region for December 2024.
- Determine the weekly sellout quantity trend for the segment 'Mid-Range' for the priceband 'Above 40K' in 2023.
- Calculate the yearly sellin quantity for each sales category in the region 'East 2' in 2023.
- Show the competitor wise market share for the 'West 3' region for Q4 2024.
- List the top 10 models by sellout value for the price band '20K-30K' in September 2023.
- Determine the month with the highest average sellout value per day for the GT channel for 2024.
- Compute the month-wise sellout quantity for the model 'Galaxy Note 20' in 2023.
- Calculate the market share of the top 3 competitors in the 'MT' channel for August 2024.
- Find the top 5 performing regions by sellin amount for the segment 'Economy' in Q3 2024.
- Determine the average daily sellout value for the region 'North 1' in February 2023.
- Show the month-on-month sellout trends for the family name 'iPhone' in 2024.
- Calculate the total yearly sellin quantity for each model in the 'South 2' region in 2023.
- Determine the average quarterly sellout quantity for the segment 'Mid-Range' in 2023.
- Compute the monthly counter sellout volume for the channel 'Online' in 2024.
- List the top 10 models by sellout value for the North 2 region in October 2023.
- Determine the price band that contributed the most to the sellout value for Samsung in Q1 2024.
- Calculate the monthly cumulative sellout value for each competitor in the GT channel for 2023.
- Find the model with the lowest sellin quantity for the 'West 1' region in 2024.
- Show the competitor-wise market share for the 'Central' region for each month in 2023.
- List the top 5 regions by sellout quantity for the segment 'Premium' in Q1 2023.
- Determine the average sellout value for the product group 'Tablets' by week in 2024.
- Compute the month-wise sellout value for the model name 'Galaxy S21' in May 2023.
- Calculate the yearly counter sellout volume for the channel 'MT' in 2024.
- Determine the average price for models sold in region 'East 1' in May 2024.
- List the top 3 competitors by sellout value for the 'North 1' region in Q2 2023.
- Show the month-on-month counter sellout volume for 'Apple' in the 'Online' channel in 2023.
- Calculate the cumulative sellout quantity for the 'GT' channel by product group in 2024.
- Determine the total sellin amount for each family name in the 'West 2' region in Q4 2024.
- Compute the average sellout value for the 'Premium' segment by day for November 2023.
- List the month-wise sellout quantity for 'Samsung' in the 'MT' channel for 2024.
- Determine the total sellout value for the 'Central' region by competitor for each week in 2023.
- Calculate the quarterly sellout value for the price band 'Below 10K' in 2024.
- Find the model with the highest weekly sellin amount for the 'North 1' region in July 2023.
- Show the competitor-wise market share in the 'Online' channel for the 'Mid-Range' segment by quarter in 2023.
- Determine the average daily sellout quantity for the price band '30K-40K' in October 2024.
- Compute the month-on-month sellout value for the product group 'Wearables' in the region 'South 1' in 2023.
- List the top 10 competitors by market share in the 'East 2' region by month in 2024.
- Calculate the total counter sellout volume for the 'West 1' region by family name in Q3 2023.
These questions will cover a range of analytics and data-fetching tasks, testing the vendor's ability to work with various SQL functions and aggregations.
- User
This query will run on a database whose unique column values are represented in the key value pair below:
column name :'Segment',unique_values: {'Accessories','Note Pc','Smart Phone','Tab','Wearable'}
column name : 'Region',unique_values: { 'B2b', 'East 1', 'East 2', 'MT', 'North 1', 'North 2', 'North 3', 'North 4', 'ONLINE', 'South 1', 'South 2', 'South 3', 'West 1', 'West 2', 'West 3', 'West 4'}
column name : 'Channel',unique_values: { 'B2B', 'GT', 'MT', 'ON', 'ONLINE'}
column name : 'WeekYear',unique_values: { '22.52W', '23.1W', '23.2W', '23.3W', '23.4W', '23.5W', '23.6W', '23.7W', '23.8W', '23.9W', '23.10W', '23.11W', '23.12W', '23.13W', '23.14W', '23.15W', '23.16W', '23.17W', '23.18W', '23.19W', '23.20W', '23.21W', '23.22W', '23.23W', '23.24W', '23.25W', '23.26W', '23.27W', '23.28W', '23.29W', '23.30W', '23.31W', '23.32W', '23.33W', '23.34W', '23.35W', '23.36W', '23.37W', '23.38W', '23.39W', '23.40W', '23.41W', '23.42W', '23.43W', '23.44W', '23.45W', '23.46W', '23.47W', '23.48W', '23.49W', '23.50W', '23.51W', '23.52W', '24.1W', '24.2W', '24.3W', '24.4W', '24.5W', '24.6W', '24.7W', '24.8W', '24.9W', '24.10W', '24.11W', '24.12W', '24.13W', '24.14W', '24.15W', '24.16W', '24.17W'}
column name : 'SalesType',unique_values: { 'Sell Out'}
column name : 'SalesCategory',unique_values: { 'Normal'}
column name : 'PriceBand',unique_values: { '6 K - 10 K', '10 K-15 K', '15 K-20 K', '20 K - 30 K', '30 K - 40 K', 'Above 40K', 'Below 6K'}
column name : 'ProductGroup',unique_values: { 'Accessories', 'Note Pc', 'Total Mobile'}
column name : 'Model',unique_values: { 'A032FD', 'A035FD', 'A035FG', 'A037FD', 'A037FG', 'A042FD', 'A042FH', 'A042FK', 'A045FD', 'A045FG', 'A045FH', 'A047FG', 'A047FH', 'A055FD', 'A055FH', 'A057FG', 'A057FH', 'A105FG', 'A107FD', 'A107FG', 'A125FG', 'A125FH', 'A125FJ', 'A127FG', 'A127FJ', 'A127FL', 'A127FN', 'A135FG', 'A135FH', 'A135FJ', 'A145FD', 'A145FG', 'A145FX', 'A146BD', 'A146BG', 'A146BH', 'A146BI', 'A156EN', 'A156EP', 'A156EQ', 'A205FG', 'A207FD', 'A207FG', 'A217FF', 'A217FG', 'A217FL', 'A225FR', 'A226BH', 'A226BJ', 'A235FH', 'A235FT', 'A236EG', 'A236EH', 'A256EG', 'A256EH', 'A260GG', 'A300H', 'A305FF', 'A307FV', 'A307FW', 'A315FW', 'A325FH', 'A325FI', 'A336EP', 'A336ER', 'A346EA', 'A346EC', 'A346EE', 'A346EQ', 'A346ER', 'A356EJ', 'A356EK', 'A500G', 'A505FD', 'A505FG', 'A507FV', 'A507FW', 'A510F', 'A515FH', 'A515FW', 'A520F', 'A525FG', 'A525FH', 'A528BD', 'A528BG', 'A536ED', 'A536EG', 'A536EH', 'A546EC', 'A546ED', 'A556EG', 'A556EH', 'A556EZ', 'A600GG', 'A600GH', 'A605G', 'A700F', 'A705GH', 'A707FM', 'A707FW', 'A710F', 'A715FW', 'A720F', 'A725FG', 'A725FH', 'A730F', 'A736BG', 'A736BH', 'A750FD', 'A750FH', 'A800F', 'A800I', 'A805F', 'A910F', 'A920FD', 'A920FG', 'C701F', 'C900F', 'E025FE', 'E025FF', 'E045FG', 'E135FD', 'E135FG', 'E145FD', 'E146BD', 'E146BG', 'E146BH', 'E156BD', 'E156BG', 'E225FD', 'E225FH', 'E236BG', 'E236BH', 'E346BD', 'E346BH', 'E426BG', 'E426BH', 'E500H', 'E546BH', 'E625FD', 'E625FG', 'E700H', 'EF-CG850B', 'EF-CG850W', 'EF-CG900D', 'EF-CG900H', 'EF-CG900K', 'EF-CG920B', 'EF-CG920E', 'EF-CG920F', 'EF-CG920G', 'EF-CG920L', 'EF-CG920P', 'EF-CG920S', 'EF-CG920W', 'EF-CG930', 'EF-CG935', 'EF-CN910P', 'EF-CN910R', 'EF-EA525P', 'EF-EA536P', 'EF-EA725P', 'EF-KG991C', 'EF-KG996C', 'EF-NG930', 'EF-NG991P', 'EF-NG996P', 'EF-NG998P', 'EF-NN950P', 'EF-NS906', 'EF-WG925B', 'EF-WG925E', 'EF-WG925F', 'EF-WG925P', 'EF-WG925S', 'EF-WG925W', 'EF-WN915B', 'EF-ZA346C', 'EF-ZA356C', 'EF-ZA520C', 'EF-ZA546C', 'EF-ZA556C', 'EF-ZG780C', 'EF-ZG920F', 'EF-ZG920L', 'EF-ZG925B', 'EF-ZG930', 'EF-ZG935', 'EF-ZG950C', 'EF-ZG955C', 'EF-ZG960C', 'EF-ZG965C', 'EF-ZG970C', 'EF-ZG973C', 'EF-ZG975C', 'EF-ZG980C', 'EF-ZG985C', 'EF-ZG988C', 'EF-ZG990', 'EF-ZG991C', 'EF-ZG996C', 'EF-ZG998C', 'EF-ZN920E', 'EF-ZN950C', 'EF-ZN960C', 'EF-ZN980C', 'EF-ZN985C', 'EF-ZS711C', 'EF-ZS901', 'EF-ZS906', 'EF-ZS908', 'EF-ZS911C', 'EF-ZS916C', 'EF-ZS918C', 'EF-ZS921C', 'EF-ZS926C', 'EF-ZS928C', 'F127GG', 'F127GI', 'F415FD', 'F415FG', 'F700FD', 'F711BA', 'F711BE', 'F721BA', 'F721BE', 'F721BS', 'F731BA', 'F731BE', 'F731GA', 'F731GE', 'F731IA', 'F731IE', 'F731UA', 'F731UE', 'F731YA', 'F731YE', 'F900FD', 'F916BA', 'F926BD', 'F926BG', 'F936BD', 'F936BG', 'F936BH', 'F946BD', 'F946BG', 'F946BH', 'F946ID', 'F946IG', 'F946UD', 'F946UG', 'G130', 'G313', 'G313HU', 'G316HU', 'G350', 'G355', 'G360F', 'G360H', 'G361H', 'G530H', 'G531F', 'G532G', 'G550F', 'G550FY', 'G556BD', 'G570F', 'G570FO', 'G600F', 'G600FY', 'G610F', 'G610FH', 'G610FI', 'G610FO', 'G610FY', 'G611FD', 'G611FF', 'G611FG', 'G615F', 'G615FU', 'G750H', 'G770FS', 'G770FT', 'G780FN', 'G780FO', 'G781BG', 'G800H', 'G850Y', 'G885F', 'G900', 'G900I', 'G920IA', 'G925IA', 'G925IE', 'G928GA', 'G930FU', 'G935FD', 'G935FU', 'G950FD', 'G955FD', 'G955FG', 'G960FD', 'G960FG', 'G960FH', 'G965FD', 'G965FG', 'G965FH', 'G970FD', 'G973FD', 'G973FG', 'G975FD', 'G975FG', 'G980FD', 'G985FD', 'G988BP', 'G990B3', 'G990B4', 'G990EG', 'G990EI', 'G991BD', 'G991BG', 'G996BD', 'G996BG', 'G998BG', 'G998BH', 'G7102', 'G7202', 'I8262', 'I8552', 'I9060', 'I9060I', 'I9082', 'I9152', 'I9192', 'I9200', 'I9230', 'I9300', 'I9500', 'J100H', 'J110H', 'J120G', 'J200G', 'J200GD', 'J210F', 'J210FY', 'J250F', 'J260G', 'J260GI', 'J320F', 'J320FY', 'J400FD', 'J400FH', 'J415FF', 'J500F', 'J510F', 'J600GF', 'J600GG', 'J600GH', 'J610FD', 'J610FG', 'J700F', 'J701F', 'J701FY', 'J710F', 'J710FY', 'J720F', 'J730G', 'J810GF', 'J810GG', 'M013F7', 'M013FD', 'M013FG', 'M015GD', 'M017FG', 'M022GB', 'M022GD', 'M025FE', 'M025FF', 'M045FD', 'M045FG', 'M045FK', 'M105FD', 'M105FG', 'M107FD', 'M115FD', 'M115FE', 'M127GG', 'M127GH', 'M135FP', 'M135FQ', 'M136BD', 'M136BH', 'M145FD', 'M145FH', 'M146BD', 'M146BG', 'M146BH', 'M156BD', 'M156BG', 'M205FD', 'M205FG', 'M215FD', 'M215FG', 'M215GD', 'M215GH', 'M305FD', 'M305FE', 'M305FG', 'M307FD', 'M307FG', 'M307FH', 'M315FD', 'M315FG', 'M315FH', 'M317FD', 'M317FE', 'M325FB', 'M325FC', 'M326BH', 'M326BI', 'M336BP', 'M336BR', 'M346BD', 'M346BH', 'M346BL', 'M405FD', 'M426BG', 'M426BH', 'M515FD', 'M515FE', 'M526BH', 'M526BI', 'M536BE', 'M536BF', 'M556BA', 'M556BC', 'M556BD', 'N770FN', 'N770FO', 'N910G', 'N915G', 'N920GA', 'N920GE', 'N950FD', 'N960FD', 'N960FH', 'N970FD', 'N975FD', 'N975FG', 'N980FG', 'N986BG', 'N7100', 'N7500', 'N8000', 'N9000', 'N9208U', 'N9208V', 'NP340XLA', 'NP550XED', 'NP554XED-KA1', 'NP554XED-KA2', 'NP641BED', 'NP730QED', 'NP730QFGKA1', 'NP730QFGKA2', 'NP730QFGKA3', 'NP734QFG-KA2', 'NP750QFGKA1', 'NP750QFGKA2', 'NP750QFGKA3', 'NP750QGKKG1', 'NP750QGKKG2', 'NP750QGKKG3', 'NP750XED', 'NP750XFGKA2', 'NP750XFGKA3', 'NP750XFGKB1', 'NP750XFGKB2', 'NP750XFGKB3', 'NP750XGKKG1', 'NP750XGKKG2', 'NP750XGKKG3', 'NP750XGKKS1', 'NP750XGKKS2', 'NP750XGKKS3', 'NP754XED-KC1', 'NP754XED-KC2', 'NP754XFG-KB1', 'NP754XFG-KB2', 'NP754XFGKA1', 'NP930QED', 'NP930QED-KH1', 'NP930XED', 'NP934QED-KJ2', 'NP934XED-KB2', 'NP940XFGKC1', 'NP940XFGKC4', 'NP940XFGKC5', 'NP940XGKKG1', 'NP940XGKKG2', 'NP940XGKKG3', 'NP940XGKKS1', 'NP944XFG-KC2', 'NP944XFGKC1', 'NP950QED', 'NP950QED-KH1', 'NP950XED', 'NP960QFGKA1', 'NP960QFGKA2', 'NP960QFGKA3', 'NP960QGKKG1', 'NP960QGKKG2', 'NP960XFGKC1', 'NP960XFGKC2', 'NP960XFHXA1', 'NP960XGKKG1', 'NP960XGKKG2', 'NP960XGKKG3', 'NP964QFG-KA1', 'NP964XFGKC2', 'NP964XFH-XA1', 'P610N', 'P613NA', 'P613NE', 'P615N', 'P619NA', 'P619NE', 'P3100', 'P5200', 'P6010', 'P9010', 'R140N', 'R170N', 'R175N', 'R175NB', 'R177N', 'R180N', 'R190N', 'R210N', 'R220NZ', 'R322N', 'R323N', 'R324N', 'R325N', 'R365N', 'R370N', 'R375N', 'R390N', 'R400N', 'R500N', 'R510N', 'R600N', 'R760N', 'R770N', 'R800N', 'R805F', 'R810N', 'R815F', 'R820NS', 'R820NZ', 'R825F', 'R825FZ', 'R840N', 'R845F', 'R850N', 'R855F', 'R860N', 'R865N', 'R870N', 'R875N', 'R880N', 'R885N', 'R890N', 'R895N', 'R900N', 'R905F', 'R910N', 'R915F', 'R920N', 'R925F', 'R930N', 'R935F', 'R940N', 'R945F', 'R950N', 'R955F', 'R960N', 'R965F', 'R3600', 'R3810', 'R7200', 'R7320', 'S711BB', 'S711BC', 'S711ZB', 'S711ZC', 'S901ED', 'S901EG', 'S906ED', 'S906EG', 'S908EG', 'S908EH', 'S908EP', 'S911BB', 'S911BC', 'S911LB', 'S911LC', 'S916BB', 'S916BC', 'S918BC', 'S918BQ', 'S918BW', 'S921BC', 'S921BL', 'S921BM', 'S921BQ', 'S926BB', 'S926BC', 'S926BL', 'S926BM', 'S928BC', 'S928BL', 'S928BM', 'S928BN', 'S928BQ', 'S928BW', 'S5282', 'S5303', 'S5312', 'S5360', 'S6012', 'S6102', 'S6312', 'S6812', 'S7262', 'S7392', 'S7562', 'S7582', 'T110', 'T111', 'T116I', 'T116N', 'T220N', 'T225N', 'T231', 'T285N', 'T285Y', 'T290N', 'T295N', 'T331', 'T355Y', 'T385N', 'T395N', 'T500N', 'T500NG', 'T505N', 'T510N', 'T515N', 'T531', 'T561N', 'T595N', 'T705', 'T720N', 'T725N', 'T733N', 'T735NA', 'T735NE', 'T800N', 'T805', 'T815Y', 'T819Y', 'T825N', 'T835N', 'T865N', 'T870N', 'T875N', 'T970N', 'T975N', 'T2100', 'T2110', 'T3100', 'T3110', 'UNMAPPED', 'WA510', 'WA710', 'X110NA', 'X115NA', 'X200NA', 'X200NE', 'X205NA', 'X205NE', 'X210NA', 'X210NE', 'X216BA', 'X216BE', 'X510NA', 'X510NE', 'X516BA', 'X516BE', 'X610NA', 'X610NE', 'X616BA', 'X616BE', 'X700NA', 'X706BA', 'X710NA', 'X710NE', 'X716BA', 'X716BE', 'X800NA', 'X806BA', 'X810NA', 'X816BA', 'X900NE', 'X906BE', 'X910NA', 'X910NE', 'X916BA', 'X916BE', 'Z130H', 'Z200F', 'Z300H', 'Z400F', 'ZA510', 'ZA710'}
column name : 'ModelName', unique_values: { 'A 70', 'A 70S (6GB+128GB)', 'A 70S (8GB+128GB)', 'A2 CORE', 'A03-CORE (2/32GB)', 'A03 (3/32GB)', 'A03 (4/64GB)', 'A03S (3/32GB)', 'A03S (4/64GB)', 'A04 (3/32GB)', 'A04 (4/64GB)', 'A04 (4/128GB)', 'A04E (3/32GB)', 'A04E (3/64GB)', 'A04E (4/128GB)', 'A04S (4/64GB)', 'A04S (4/128GB)', 'A05 (4/64GB)', 'A05 (6/128GB)', 'A5_2017 CLEAR VIEW', 'A05S (4/128GB)', 'A05S (6/128GB)', 'A6 (32 GB)', 'A6 (64 GB)', 'A6 PLUS', 'A7 2018 (64 GB)', 'A7 2018 (128 GB)', 'A9 2018 (6GB/128GB)', 'A9 2018 (8GB/128GB)', 'A10 (2/32GB)', 'A10S (2/32 GB)', 'A10S (3/32 GB)', 'A12 (4/64GB)', 'A12 (4/128GB)', 'A12 (6/128GB)', 'A13 (4/64GB)', 'A13 (4/128GB)', 'A13 (6/128GB)', 'A14 (4/64GB)', 'A14 (4/128GB)', 'A14 (6/128GB)', 'A14 5G (4/64GB)', 'A14 5G (4/128GB)', 'A14 5G (6/128GB)', 'A14 5G (8/128GB)', 'A15 5G (6/128GB)', 'A15 5G (8/128GB)', 'A15 5G (8/256GB)', 'A20 (3/32GB)', 'A20S (3/32GB)', 'A20S (4/64GB)', 'A22 (6/128GB)', 'A22 5G (6/128GB)', 'A22 5G (8/128GB)', 'A23 (6/128GB)', 'A23 (8/128GB)', 'A23 5G (6/128GB)', 'A23 5G (8/128GB)', 'A25 5G (8/128GB)', 'A25 5G (8/256GB)', 'A30', 'A30S (4GB+64GB)', 'A30S (128GB)', 'A32 (6/128GB)', 'A32 (8/128GB)', 'A33 5G (6/128GB)', 'A33 5G (8/128GB)', 'A34 5G (6/128GB)', 'A34 5G (8/128GB)', 'A34 5G (8/256GB)', 'A34_5G SMART VIEW WALLET COVER', 'A35 (8/128GB)', 'A35 (8/256GB)', 'A35 SMART VIEW WALLET CASE', 'A50 (4GB+64GB)', 'A50 (6GB+64GB)', 'A50S (4GB+128GB)', 'A50S (6GB+128GB)', 'A52 (6/128GB)', 'A52 (8/128GB)', 'A52 S VIEW WALLET COVER', 'A52S 5G (6/128GB)', 'A52S 5G (8/128GB)', 'A53-5G SMART VIEW COVER_JDM', 'A53 5G (6/128GB)', 'A53 5G (8/128GB)', 'A53 5G (8/256GB)', 'A54 5G (8/128GB)', 'A54 5G (8/256GB)', 'A54_5G SMART VIEW WALLET COVER', 'A55 (8/128GB)', 'A55 (8/256GB)', 'A55 (12/256GB)', 'A55 SMART VIEW WALLET CASE', 'A72 (8/128GB)', 'A72 (8/256GB)', 'A72 S VIEW WALLET COVER', 'A73 5G (8/128GB)', 'A73 5G (8/256GB)', 'A80', 'ACCESSORIES', 'ALPHA S VIEW COVER', 'BEYOND0_S10E CLEAR VIEW COVER', 'BEYOND1 CLEAR VIEW COVER', 'BEYOND2 CLEAR VIEW COVER', 'BUDS', 'BUDS FE', 'BUDS LIVE', 'BUDS PRO', 'BUDS+ BTS', 'BUDS2', 'BUDS2 PRO', 'CORE', 'CORE PRIME', 'CORE PRIME 4G', 'F02S (3/32GB)', 'F02S (4/64GB)', 'F04 (4/64GB)', 'F13 (4/64GB)', 'F13 (4/128GB)', 'F14 (4/64GB)', 'F14 5G (4/64GB)', 'F14 5G (4/128GB)', 'F14 5G (6/128GB)', 'F15 5G (4/128GB)', 'F15 5G (6/128GB)', 'F22 (4/64GB)', 'F22 (6/128GB)', 'F23 5G (4/128GB)', 'F23 5G (6/128GB)', 'F34 5G (6/128GB)', 'F34 5G (8/128GB)', 'F42 5G (6/128GB)', 'F42 5G (8/128GB)', 'F54 5G (8/256GB)', 'F62 (6/128GB)', 'F62 (8/128GB)', 'FIT3', 'G. NOTE 9 512 GB', 'GALAXY-A5-2017', 'GALAXY-A5X', 'GALAXY-A7-2017', 'GALAXY-A7X', 'GALAXY-A8-STAR', 'GALAXY-A8+ (2018)', 'GALAXY-A9-PRO (2016)', 'GALAXY-C7-PRO', 'GALAXY-GRAND-PRIME-PLUS', 'GALAXY-J1X', 'GALAXY-J2', 'GALAXY-J5X', 'GALAXY-J7-MAX', 'GALAXY-J7 2016', 'GALAXY-ON-MAX', 'GALAXY-ON5 PRO', 'GALAXY-ON7 PRO', 'GALAXY-TAB-ACTIVE2', 'GALAXY-TAB-S2-L', 'GALAXY A3', 'GALAXY A5', 'GALAXY A7', 'GALAXY A8', 'GALAXY A21S (4/64GB)', 'GALAXY A21S (6/64GB)', 'GALAXY A21S (6/128GB)', 'GALAXY A31 (6/128GB)', 'GALAXY A51 (6/128GB)', 'GALAXY A51 (8/128GB)', 'GALAXY A71 (8/128GB)', 'GALAXY ACE NXT', 'GALAXY ALPHA', 'GALAXY BOOK BIZ', 'GALAXY BOOK GO', 'GALAXY BOOK2', 'GALAXY BOOK2 360', 'GALAXY BOOK2 PRO', 'GALAXY BOOK2 PRO 360', 'GALAXY BOOK3', 'GALAXY BOOK3 360', 'GALAXY BOOK3 PRO', 'GALAXY BOOK3 PRO 360', 'GALAXY BOOK3 ULTRA', 'GALAXY BOOK4', 'GALAXY BOOK4 360', 'GALAXY BOOK4 PRO', 'GALAXY BOOK4 PRO 360', 'GALAXY C9 PRO', 'GALAXY CORE 2', 'GALAXY E5', 'GALAXY E7', 'GALAXY F12 (4/64GB)', 'GALAXY F12 (4/128GB)', 'GALAXY F41 (6/64GB)', 'GALAXY F41 (6/128GB)', 'GALAXY FAME', 'GALAXY FIT', 'GALAXY FIT LITE', 'GALAXY FIT2', 'GALAXY FOLD', 'GALAXY GOLDEN', 'GALAXY GRAND NEO PLUS', 'GALAXY J MAX', 'GALAXY J3', 'GALAXY J3 16 GB', 'GALAXY J5 PRIME', 'GALAXY J7 PRIME', 'GALAXY M01 (3/32GB)', 'GALAXY M01 CORE (1/16GB)', 'GALAXY M01 CORE (2/32GB)', 'GALAXY M01S (3/32GB)', 'GALAXY M02S (3/32GB)', 'GALAXY M02S (4/64GB)', 'GALAXY M11 (3/32GB)', 'GALAXY M11 (4/64GB)', 'GALAXY M12 (4/64GB)', 'GALAXY M12 (6/128GB)', 'GALAXY M21 (4/64GB)', 'GALAXY M21 (6/128GB)', 'GALAXY M30S (4/64GB)', 'GALAXY M30S (4/128GB)', 'GALAXY M30S (6/128GB)', 'GALAXY M31 (6/64GB)', 'GALAXY M31 (6/128GB)', 'GALAXY M31 (8/128GB)', 'GALAXY M31S (6/128GB)', 'GALAXY M31S (8/128GB)', 'GALAXY M51 (6/128GB)', 'GALAXY M51 (8/128GB)', 'GALAXY MEGA 6.3', 'GALAXY MUSIC', 'GALAXY NOTE', 'GALAXY NOTE 20', 'GALAXY NOTE 20 ULTRA', 'GALAXY NOTE EDGE', 'GALAXY NOTE5 DUAL SIM', 'GALAXY ON8', 'GALAXY POCKET NEO', 'GALAXY S DUOS-2', 'GALAXY S DUOS 3', 'GALAXY S5', 'GALAXY S5 LTE', 'GALAXY S5 MINI', 'GALAXY S7 EDGE 128 GB', 'GALAXY S10 LITE (8/128 GB)', 'GALAXY S10 LITE (8/512 GB)', 'GALAXY S20 (8/128GB)', 'GALAXY S20 FE (8/128GB)', 'GALAXY S20 FE (8/256GB)', 'GALAXY S20 ULTRA (12/128GB)', 'GALAXY S20+ BTS EDITION', 'GALAXY STAR', 'GALAXY TAB 2', 'GALAXY TAB A 7.0', 'GALAXY TAB E', 'GALAXY TAB S2', 'GALAXY TREND', 'GALAXY WATCH ACTIVE', 'GALAXY WATCH3_41MM_BT', 'GALAXY WATCH3_41MM_LTE', 'GALAXY WATCH3_45MM_BT', 'GALAXY WATCH3_45MM_LTE', 'GALAXY Y', 'GALAXY Y_DUOS', 'GALAXY YOUNG', 'GALAXY Z FLIP', 'GALAXY Z FOLD 3 (256 GB)', 'GALAXY Z FOLD 3 (512 GB)', 'GALAXY Z FOLD2 5G', 'GEAR-2 NEO', 'GEAR FIT2', 'GEAR FIT2 PRO', 'GEAR ICONX (2018)', 'GEAR S2', 'GEAR S2 CLASSIC', 'GEAR S3 CLASSIC', 'GEAR S3 FRONTIER', 'GEAR SPORT', 'GEAR VR', 'GEAR VR 2', 'GEAR VR3', 'GEAR VR4', 'GLOBE', 'GOYA', 'GRAND', 'GRAND 2', 'GRAND MAX', 'GRAND NEO', 'GRAND PRIME', 'GRAND PRIME 4G', 'GRAND QUATTRO', 'GREAT CLEAR VIEW STANDING COVE', 'GREAT LED VIEW COVER', 'J1', 'J1 ACE', 'J2 2016', 'J2 2018', 'J2 CORE', 'J2 CORE (16GB)', 'J2 PRO 2016', 'J2 REFRESH', 'J4 (16 GB)', 'J4 (32 GB)', 'J4 PLUS (32 GB)', 'J5', 'J5 PRIME 32 GB', 'J6 (32 GB)', 'J6 (64 GB)', 'J6 PLUS (32GB)', 'J6 PLUS (64 GB)', 'J7', 'J7-DUO', 'J7-NXT 32 GB', 'J7 NXT', 'J7 PRIME 2 (32GB)', 'J7 PRIME 32GB', 'J7 PRO', 'J8 2018', 'M01 CORE (1/16GB) [AIRTEL]', 'M02 (2/32GB)', 'M02 (3/32GB)', 'M04 (3/32GB)', 'M04 (4/64GB)', 'M04 (4/128GB)', 'M10 (16GB)', 'M10 (32GB)', 'M10S', 'M13 (4/64GB)', 'M13 (6/128GB)', 'M13 5G (4/64GB)', 'M13 5G (6/128GB)', 'M14 (4/64GB)', 'M14 (6/128GB)', 'M14 5G (4/64GB)', 'M14 5G (4/128GB)', 'M14 5G (6/128GB)', 'M15 (4/128GB)', 'M15 (6/128GB)', 'M20 (32GB)', 'M20 (64GB)', 'M21 PRIME (4/64GB)', 'M21 PRIME (6/128GB)', 'M30 (3/32GB)', 'M30 (64 GB)', 'M30 (128 GB)', 'M32 (4/64GB)', 'M32 (6/128GB)', 'M32 5G (6/128GB)', 'M32 5G (8/128GB)', 'M33 5G (6/128GB)', 'M33 5G (8/128GB)', 'M34 5G (6/128GB)', 'M34 5G (8/128GB)', 'M34 5G (8/256GB)', 'M40 (128GB)', 'M42 5G (6/128GB)', 'M42 5G (8/128GB)', 'M52 5G (6/128GB)', 'M52 5G (8/128GB)', 'M53 5G (6/128GB)', 'M53 5G (8/128GB)', 'M55 (8/128GB)', 'M55 (8/256GB)', 'M55 (12/256GB)', 'MEGA 2', 'MEGA 5.8', 'NOTE-5 32GB', 'NOTE-5 64GB', 'NOTE 2', 'NOTE 3', 'NOTE 3 LITE', 'NOTE 4', 'NOTE 8', 'NOTE 9 128GB', 'NOTE 9 CLEAR VIEW STANDING COV', 'NOTE 10 (256 GB)', 'NOTE 10.1 - 2014', 'NOTE 10+ (256 GB)', 'NOTE 10+ (512 GB)', 'NOTE PRO', 'NOTE10 LITE (6/128GB)', 'NOTE10 LITE (8/128GB)', 'NOTE20_CLEAR VIEW COVER', 'ON 6 (64 GB)', 'ON 8 (2018)', 'ON NXT (16GB)', 'ON NXT 64GB', 'ON5', 'ON7', 'ON7 PRIME 32GB', 'ON7 PRIME 64GB', 'ONNXT', 'OTHERS', 'PALETTE_O1 CLEAR VIEW COVER', 'PALETTE_O1 LED BACK COVER', 'PALETTE_O1 LED VIEW COVER', 'PALETTE_P3 CLEAR VIEW COVER', 'PALETTE_P3 LED VIEW COVER', 'PALETTE_T2 CLEAR VIEW COVER', 'PALETTE_T2 LED BACK COVER', 'PALETTE_T2 LED VIEW COVER', 'R9 SMART CLEAR VIEW COVER_JDM', 'RAINBOW B0 CLEAR VIEW', 'RAINBOW G0 CLEAR VIEW', 'RAINBOW G0 LED VIEW', 'RAINBOW R0 CLEAR VIEW', 'S DUOS', 'S DUOS 3 VE', 'S III', 'S4', 'S4 MINI', 'S6 32GB', 'S6 EDGE 32GB', 'S6 EDGE 64GB', 'S6 EDGE+ 32GB', 'S7', 'S7 EDGE', 'S8', 'S8+', 'S8+ - 128 GB', 'S9 64GB', 'S9 128GB', 'S9 256GB', 'S9+ 64GB', 'S9+ 128GB', 'S9+ 256GB', 'S10 (128 GB)', 'S10 (512 GB)', 'S10+ (128 GB)', 'S10+ (512 GB)', 'S10E', 'S20 FE 5G (8/128GB)', 'S20 FE CLEAR VIEW COVER', 'S21 5G (8/128GB)', 'S21 5G (8/256GB)', 'S21 FE 5G (8/128GB)', 'S21 FE 5G (8/256GB)', 'S21 FE 5G 2023 (8/128GB)', 'S21 FE 5G 2023 (8/256GB)', 'S21 ULTRA 5G (12/256GB)', 'S21 ULTRA 5G (16/512GB)', 'S21+ 5G (8/128GB)', 'S21+ 5G (8/256GB)', 'S22 (8/128GB)', 'S22 (8/256GB)', 'S22 ULTRA (12/1TB)', 'S22 ULTRA (12/256GB)', 'S22 ULTRA (12/512GB)', 'S22+ (8/128GB)', 'S22+ (8/256GB)', 'S23 (8/128GB)', 'S23 (8/256GB)', 'S23 FE (8/128GB)', 'S23 FE (8/256GB)', 'S23 FE SMART VIEW WALLET CASE', 'S23 SMART VIEW WALLET CASE', 'S23 ULTRA (12/1TB)', 'S23 ULTRA (12/256GB)', 'S23 ULTRA (12/512GB)', 'S23 ULTRA SMART VIEW WALLET CA', 'S23+ (8/256GB)', 'S23+ (8/512GB)', 'S23+ SMART VIEW WALLET CASE', 'S24 (8/256GB)', 'S24 (8/512GB)', 'S24 SMART VIEW WALLET CASE', 'S24 U SMART VIEW WALLET CASE', 'S24 ULTRA (12/1TB)', 'S24 ULTRA (12/256GB)', 'S24 ULTRA (12/512GB)', 'S24+ (12/256GB)', 'S24+ (12/512GB)', 'S24+ SMART VIEW WALLET CASE', 'SAMSUNG Z2', 'SAMSUNG Z4', 'STAR 2', 'STAR ADVANCE', 'STAR CLEAR VIEW STANDING COVER', 'STAR PRO', 'STAR2 CLEAR VIEW STANDING COVE', 'TAB-A8 (3/32GB)', 'TAB-A8 (4/64GB)', 'TAB-A8 (WIFI) (3/32GB)', 'TAB-A8 (WIFI) (4/64GB)', 'TAB-A9 (LTE) (4/64GB)', 'TAB-A9 (WIFI) (4/64GB)', 'TAB-A9 PLUS (5G) (4/64GB)', 'TAB-A9 PLUS (5G) (8/128GB)', 'TAB-A9 PLUS (WIFI) (4/64GB)', 'TAB-A9 PLUS (WIFI) (8/128GB)', 'TAB-S8 (WIFI) (8/128GB)', 'TAB-S8 5G (8/128GB)', 'TAB-S8 PLUS (WIFI) (8/128GB)', 'TAB-S8 PLUS 5G (8/128GB)', 'TAB-S8 ULTRA (WIFI) (12/256GB)', 'TAB-S8 ULTRA 5G (12/256GB)', 'TAB-S9-FE-PLUS 5G (8/128GB)', 'TAB-S9-FE-PLUS WIFI (8/128GB)', 'TAB-S9-FE 5G (6/128GB)', 'TAB-S9-FE WIFI (6/128GB)', 'TAB-S9-PLUS (WIFI) (12/256GB)', 'TAB-S9-PLUS 5G (12/256GB)', 'TAB-S9-ULTRA (WIFI) (12/256GB)', 'TAB-S9-ULTRA (WIFI) (12/512GB)', 'TAB-S9-ULTRA 5G (12/256GB)', 'TAB-S9-ULTRA 5G (12/512GB)', 'TAB-S9 5G (8/128GB)', 'TAB-S9 5G (12/256GB)', 'TAB-S9 FE (5G) (8/256GB)', 'TAB-S9 FE (WIFI) (8/256GB)', 'TAB-S9 FE PLUS (5G) (12/256GB)', 'TAB-S9 FE PLUS (WIFI) (12/256G', 'TAB-S9 WIFI (8/128GB)', 'TAB-S9 WIFI (12/256GB)', 'TAB 3 NEO WIFI', 'TAB 3V', 'TAB 4-7', 'TAB 4-8', 'TAB 4-10', 'TAB A', 'TAB A 10.1 (WI-FI ONLY)', 'TAB A 10.1 (WI-FI + LTE)', 'TAB A 10.5', 'TAB A7 (LTE)', 'TAB A7 (WIFI) (3/32GB)', 'TAB A7 (WIFI) (3/64GB)', 'TAB A7 LITE (LTE)', 'TAB A7 LITE (WIFI)', 'TAB A8', 'TAB A8 (WIFI)', 'TAB B2B', 'TAB S-10.5 WIFI', 'TAB S 8.4', 'TAB S 10.5', 'TAB S3', 'TAB S4', 'TAB S5E (WI-FI + LTE)', 'TAB S5E (WI-FI ONLY)', 'TAB S6 LITE (LTE)', 'TAB S6 LITE (LTE) (4/128GB)', 'TAB S6 LITE (WIFI)', 'TAB S6 LITE (WIFI) (4/64GB)', 'TAB S6 LITE (WIFI) (4/128GB)', 'TAB S6(LTE)', 'TAB S7 (LTE)', 'TAB S7 (WIFI)', 'TAB S7 FE (LTE) (4/64GB)', 'TAB S7 FE (LTE) (6/128GB)', 'TAB S7 FE (WIFI)', 'TAB S7+ (LTE)', 'TAB S7+ (WIFI)', 'TAB3-7', 'TAB3-7 WIFI', 'TAB3-8', 'TAB3-8 WIFI', 'TAB3 NEO', 'WATCH ACTIVE2_44MM_BT_ALUMINIU', 'WATCH ACTIVE2_44MM_BT_STEEL', 'WATCH ACTIVE2_44MM_LTE_ALUMINI', 'WATCH ACTIVE2_44MM_LTE_STEEL', 'WATCH_42MM_BT', 'WATCH_42MM_LTE', 'WATCH_46MM_BT', 'WATCH_46MM_LTE', 'WATCH4 40MM_BT', 'WATCH4 40MM_LTE', 'WATCH4 44MM_BT', 'WATCH4 44MM_LTE', 'WATCH4 CLASSIC 42MM_BT', 'WATCH4 CLASSIC 42MM_LTE', 'WATCH4 CLASSIC 46MM_BT', 'WATCH4 CLASSIC 46MM_LTE', 'WATCH5 40MM_BT', 'WATCH5 40MM_LTE', 'WATCH5 44MM_BT', 'WATCH5 44MM_LTE', 'WATCH5 PRO 45MM_BT', 'WATCH5 PRO 45MM_LTE', 'WATCH6 40MM_BT', 'WATCH6 40MM_LTE', 'WATCH6 44MM_BT', 'WATCH6 44MM_LTE', 'WATCH6 CLASSIC 43MM_BT', 'WATCH6 CLASSIC 43MM_LTE', 'WATCH6 CLASSIC 47MM_BT', 'WATCH6 CLASSIC 47MM_LTE', 'XCOVER7 (6/128GB)', 'Z FLIP 3 5G (8/128GB)', 'Z FLIP 3 5G (8/256GB)', 'Z FLIP 4 5G (8/128GB)', 'Z FLIP 4 5G (8/256GB)', 'Z FLIP 4 5G (8/256GB) BESPOKE', 'Z FLIP 5 5G (8/256GB)', 'Z FLIP 5 5G (8/512GB)', 'Z FOLD 4 5G (12/1TB)', 'Z FOLD 4 5G (12/256GB)', 'Z FOLD 4 5G (12/512GB)', 'Z FOLD 5 5G (12/1TB)', 'Z FOLD 5 5G (12/256GB)', 'Z FOLD 5 5G (12/512GB)', 'Z1', 'Z3'}
these are the possible unique value for mx_sales table
- Assistant
Given the unique column values for the
mx_salestable, we can create a diverse set of complex questions that require the vendor to demonstrate proficiency with SQL. Here's a list of 100 such questions:Questions
- What is the total sellout quantity and sellout amount for each sales category across all regions for the year 2024?
- Calculate the average price of products sold in the "North 1" region, segmented by each month in 2024.
- Determine the top 5 models by sellout value in the "MT" channel for the region "West 2" during the first quarter of 2024.
- Show the week-on-week trend in sellout quantity for "Smart Phone" under the "GT" channel for "A04 (4/64GB)" in 2024.
- Compute the total sellout and sellin quantity for each product group in the "South 1" region for the year 2023.
- Find the competitor with the highest average sellout amount per day for the model "Galaxy Note 20" in the "ONLINE" channel during 2024.
- Analyze the month-wise total sellout value trend for the "Tab" segment in the "East 1" region for the year 2024.
- Show the top 10 models by sellin amount in the "MT" channel for the month of February 2024.
- Compute the market share of each price band in sellout value for the "Wearable" segment in "West 3" for the year 2024.
- Determine the day of the week with the highest average sellout quantity for "M01 CORE (1/16GB)" in December 2024.
- Calculate the total amount of sellin and sellout by channel for "B2B" for the year 2023 in the "South 2" region.
- Find the monthly growth rate of sellout quantities for "Tab" in the "Central" region for the year 2023.
- Determine the average price of products sold in the "ONLINE" channel by week for the "Accessories" segment in 2024.
- Show the weekly trends in sellout quantities for the price band "Above 40K" in the "GT" channel for Q2 2024.
- Compute the quarterly sellin amount for the "10 K-15 K" price band for each region in 2024.
- Calculate the total sellout value for each model in the "North 3" region in May 2024.
- Determine the competitor-wise market share in the "GT" channel for the model "Galaxy Z Fold 3 (512 GB)" in June 2024.
- Show the distribution of sellout quantities across each day for April 2024 for the "Note Pc" segment.
- Analyze the annual trend in sellout value for the "S21 FE 5G (8/128GB)" model in the "South 4" region for 2023.
- Calculate the week-on-week sellout amount growth for the "West 1" region for January 2024.
- Determine the total sellout quantity for the "R90" model by competitor across each region for 2023.
- Find the top 5 performing price bands by total sellout value in the "North 4" region for Q3 2024.
- Compute the monthly market share of the "MT" channel in sellout quantities for "Tab" in 2024.
- Calculate the average daily sellout value for the "S23 FE (8/128GB)" model in October 2024 in the "East 2" region.
- Determine the most popular channel by sellout amount for "Galaxy A70" in the "East 1" region in 2023.
- Show the top 5 regions with the highest total sellout value for the "A035FD" model in H1 2024.
- Calculate the monthly cumulative sellout quantity for the "15 K-20 K" price band in the "South 4" region for 2023.
- Determine the weekly trends in sellin amount for "Accessories" in the "North 2" region for 2024.
- Find the model with the highest average price in the "GT" channel for the month of March 2024.
- Analyze the distribution of sellout quantities by product group for each region in 2023.
- Compute the total sellout value for "Galaxy Note 20 Ultra" in the "East 2" region by week for Q4 2023.
- Show the average weekly sellout quantity for the "Smart Phone" segment in the "North 1" region for May 2024.
- Determine the competitor-wise breakdown of sellout quantities for the "West 1" region for Q1 2024.
- Calculate the average weekly counter sellout value for each channel in the "Central" region in 2023.
- Find the top 10 models by market share in terms of sellout value in the "East 1" region for June 2024.
- Determine the model with the lowest average sellout quantity in the "ONLINE" channel for July 2024.
- Compute the daily sellout amount for the "Wearable" segment in "South 1" for December 2023.
- Show the weekly growth rate of sellin amounts for the "Tab" segment in the "West 3" region for 2024.
- Analyze the monthly sellout quantity trend for "20 K - 30 K" price band in the "West 2" region for 2023.
- Calculate the quarterly sum of sellout values for "Galaxy A5" in the "MT" channel for the year 2024.
- Determine the total yearly sellin quantity for each region for the price band "Below 6K" in 2023.
- Find the top 5 regions by sellout value for the competitor "Apple" in Q2 2024.
- Compute the market share of "Samsung" in the "GT" channel by sellout value for 2023.
- Calculate the week-by-week sellout trends for "Galaxy S21" in the "B2B" channel for January 2024.
- Determine the total sellout amount for each model in the "North 2" region for Q3 2023.
- Show the average monthly sellout value for the model "A14 5G (6/128GB)" in the "MT" channel for 2024.
- Analyze the daily sellout quantity for "Galaxy M21" in December 2024 in the "West 4" region.
- Determine the top 3 models by total sellin amount in the "ONLINE" channel for Q1 2023.
- Compute the weekly sellout quantity trend for the "Smart Phone" segment in the "South 2" region for 2024.
- Calculate the annual sellout value for the "ON" channel by price band in the "North 3" region for 2023.
- Find the average sellout amount per day for "RP530F" in the "South 2" region for October 2024.
- Determine the month with the highest sellout quantity for the "Note Pc" segment in the "East 1" region for 2023.
- Mention the total weekly market share of "Samsung" in sellout value for the "GT" channel for June 2024.
- Show the top 5 models by sellout volume in the "West 3" region for the price band "6 K - 10 K" for H2 2023.
- Compute the month-on-month growth rate in sellin amounts for "Accessories" in the "MT" channel for 2024.
- Determine the most popular segment by sellout quantity for "A037FG" in the "Central" region in 2023.
- Analyze the quarterly sellout value trends for "15 K-20 K" price band in the "North 4" region for 2023.
- Calculate the weekly sum of sellout quantities for the "R860N" model in the "South 1" region for 2024.
- Show the competitor-wise quarterly sellout value for the "GT" channel in the "East 3" region for 2024.
- Find the average sellout quantity per day for "R500N" in the "West 2" region for February 2024.
- Determine the day of the month with the highest sellout quantity for the "Galaxy Fold" model in 2023.
- Compute the cumulative sellout value for the "North 1" region by week for the "Accessories" segment in Q1 2024.
- Calculate the average weekly sellin quantity for the "GT" channel for the month of March 2023.
- Show the price band-wise sellout quantity breakdown for the "Smart Phone" segment in the "North 2" region for 2023.
- Determine the top 10 models by sellout value in the "East 1" region for the price band "Above 40K" in Q4 2024.
- Analyze the trends in daily sellout quantities for the "Galaxy Note 20" model in the "West 1" region for December 2024.
- Find the top 5 performing competitors in the "MT" channel by quarterly sellout value for the "South 4" region in 2023.
- Compute the month-wise total sellin amount for "Galaxy A5" in the "ONLINE" channel for 2024.
- Show the yearly sellout quantity for each product group in the "South 3" region for 2023.
- Determine the top 3 models by sellout value for the price band "20 K - 30 K" in the "North 1" region in Q3 2024.
- Calculate the average daily counter sellout volume for the "Note Pc" segment in the "Online" channel for 2023.
- Analyze the month-by-month change in sellout amounts for the "Accessories" segment in the "South 2" region in 2024.
- Show the competitor-wise sellout quantity for each channel in the "North 3" region for November 2023.
- Compute the quarterly growth in sellin quantities for "EF-CG920F" model in the "East 2" region for 2024.
- Find the average weekly sellout value for the "Galaxy S20 FE" model in the "GT" channel for February 2024.
- Determine the total sellout quantity for each competitor in the "West 4" region for Q2 2024.
- Calculate the month-on-month sellin amount trends for the "Galaxy Z Fold 3" model in the "B2B" channel for 2023.
- Show the distribution of sellout quantities by product group for the "South 1" region in 2024.
- Analyze the competitor-wise market share in the "MT" channel for the "Galaxy Note 9" model in August 2024.
- Find the top 5 regions in terms of sellout value for "R800N" in Q3 2023.
- Compute the average daily sellout value for the "EF-CN910P" model in the "East 1" region for April 2024.
- Determine the month with the highest market share in sellout quantity for the "MT" channel in the "North 4" region for 2023.
- Calculate the week-on-week growth rate in sellout amounts for the "Tab" segment in the "South 3" region for September 2024.
- Show the competitor-wise quarterly counter sellout value for the "East 2" region for 2024.
- Analyze the daily sellout quantity trends for "Galaxy Note 9" in the "MT" channel for the "North 2" region for 2023.
- Compute the monthly sellin and sellout quantities for the price band "15 K-20 K" in the "West 3" region for 2024.
- Determine the top 3 models by sellout value for each price band in the "East 1" region for Q1 2023.
- Calculate the month-by-month sellout value for the "North 4" region for each competitor in 2024.
- Show the yearly cumulative sellout quantity for "Accessories" in the "ONLINE" channel for 2023.
- Find the top 5 regions by average sellout value for the "EF-CG935" model in Q2 2024.
- Determine the month-wise total sellout quantity for the "Galaxy Watch4" series in the "West 1" region for 2023.
- Calculate the market share of "Samsung" in sellout amounts for the "MT" channel in the "Central" region for 2024.
- Show the weekly trends in sellin quantities for the "Tab" segment in the "Online" channel for Q3 2024.
- Analyze the market share of each price band by sellin value for "Galaxy F fold 4" in the "East 1" region for 2023.
- Compute the daily sellout value for the "GT" channel by product group in the "North 3" region for December 2024.
- Determine the quarterly sellout quantity for the "EF-NG930" model in the "B2B" channel in 2023.
- Show the total monthly counter sellout volume for each region for "Accessories" in 2023.
- Calculate the top 5 models by sellout quantity in the "East 2" region for the price band "30 K - 40 K" in June 2024.
- Find the average weekly sellin amount for the "GT" channel in the "South 1" region for November 2024.
- Determine the month-on-month change in sellout value for the "R970FD" Model in the "GT" channel for 2023.
These questions will assess the ability to handle various SQL operations like aggregations, joins, subqueries, and window functions. They also require skills in time series analysis and understanding of market share calculations.
- User
allquestions should be in natural language as asked by sales team,upper management,laymann language
- Assistant
Absolutely, here is a list of 100 questions in natural, layman terms as might be asked by a sales team, upper management, or non-technical stakeholders:
- What's the total number of units sold and total sales revenue for each product category across all regions in 2024?
- What’s the average price of products sold in the North 1 region for each month in 2024?
- Tell me which 5 models brought in the most sales revenue in the MT channel in West 2 during Q1 2024.
- How did the weekly sales numbers change for Galaxy A04 (4/128GB) smartphones in the GT channel throughout 2024?
- How many units did we sell and how many did we ship for each product group in South 1 in 2023?
- Which competitor had the highest average daily sales revenue for the Galaxy Note 20 in the ONLINE channel during 2024?
- Show me the monthly sales revenue trends for tablets in East 1 for 2024.
- Which 10 models had the highest shipment quantities in the MT channel for February 2024?
- What is the market share in sales value for each price range for wearables in West 3 during 2024?
- On which day of the week did we sell the most units of the M01 CORE (1/16GB) in December 2024?
- What's the total sales revenue and shipment amount for the B2B channel in South 2 for 2023?
- How has the monthly sales volume grown for tablets in the Central region for 2023?
- What's the average price of accessories sold online each week in 2024?
- How have the weekly sales volumes for products priced above 40K in the GT channel changed during Q2 2024?
- What was the total shipment amount for each price range in 2024 across all regions?
- What's the total sales revenue for each model in the North 3 region in May 2024?
- How much market share did each competitor have in the GT channel for the Galaxy Z Fold 3 (512 GB) in June 2024?
- Show me the sales volume for tablets by day in April 2024.
- How did the yearly sales revenue trend look for the Galaxy S21 FE (8/128GB) in South 4 for 2023?
- How did the weekly sales revenue change for West 1 in January 2024?
- How many units did we sell for each competitor’s R90 model in 2023?
- Which 5 price bands generated the highest sales revenue in North 4 during Q3 2024?
- How has the monthly market share in sales volume changed for the MT channel for tablets in 2024?
- What’s the average daily sales revenue for the Galaxy S21 FE (8/128GB) in East 2 for October 2024?
- Which channel generated the most sales revenue for the Galaxy A70 in East 1 for 2023?
- Which 5 regions had the highest total sales revenue for the A035FD model in H1 2024?
- How did the monthly total sales volume change for the 15 K-20 K price range in South 4 for 2023?
- What were the weekly trends in shipment amounts for accessories in North 2 during 2024?
- Which model had the highest average price in the GT channel in March 2024?
- How did the sales volume break down by product group for each region in 2023?
- What was the weekly sales revenue for the Galaxy Note 20 Ultra in East 2 during Q4 2023?
- What's the average weekly sales volume for smartphones in North 1 for May 2024?
- How many units did each competitor sell in West 1 during Q1 2024?
- What's the average weekly counter sales value for each channel in Central in 2023?
- Which 10 models had the highest market share in sales revenue in East 1 for June 2024?
- Which model had the lowest average sales volume in the ONLINE channel for July 2024?
- What were the daily sales revenues for wearables in South 1 during December 2023?
- How did weekly shipment revenue grow for tablets in West 3 during 2024?
- What were the monthly sales volume trends for the 20 K - 30 K price range in West 2 for 2023?
- What was the total sales revenue for the Galaxy A5 in the MT channel for each quarter in 2024?
- How many units did we ship to and sell for each region in 2023 for products priced below 6K?
- Which 5 regions had the highest sales revenue for Apple products in Q2 2024?
- What's Samsung's market share in sales revenue in the GT channel for 2023?
- How did weekly sales trends for the Galaxy S21 in the B2B channel look in January 2024?
- What’s the total sales revenue for each model in North 2 during Q3 2023?
- What was the average monthly sales revenue for the A14 5G (6/128GB) in the MT channel in 2024?
- What were the daily sales volumes for the Galaxy M21 in West 4 in December 2024?
- Which 3 models had the highest shipment amounts in the ONLINE channel for Q1 2023?
- How did weekly sales volumes for smartphones in South 2 change during 2024?
- What's the annual sales revenue for the ON channel by price range in North 3 for 2023?
- What's the average daily sales revenue for the RP530F in South 2 for October 2024?
- Which month had the highest sales volume for Note PCs in East 1 in 2023?
- What was Samsung’s weekly market share in sales revenue for the GT channel in June 2024?
- Which 5 models had the highest sales volume in West 3 for the 6 K - 10 K price range during H2 2023?
- How did monthly shipment revenues grow for accessories in the MT channel in 2024?
- Which product group sold the most units of the A037FG model in Central during 2023?
- What were the quarterly sales volume trends for the 15 K-20 K price range in North 4 for 2023?
- What was the weekly sales volume for the R860N model in South 1 during 2024?
- What was the competitor-wise quarterly sales revenue for the GT channel in East 3 during 2024?
- What's the average daily sales volume for the R500N model in West 2 for February 2024?
- Which day of the month had the highest sales volume for the Galaxy Fold in 2023?
- What was the cumulative weekly sales revenue for accessories in North 1 during Q1 2024?
- What was the average weekly shipment volume for the GT channel in March 2023?
- How did sales volumes break down by price range for smartphones in North 2 for 2023?
- Which 10 models had the highest sales revenue in East 1 for the Above 40K price range during Q4 2024?
- What were the daily sales volume trends for the Galaxy Note 20 in West 1 during December 2024?
- Which 5 competitors performed best in the MT channel by quarterly sales revenue in South 4 for 2023?
- How did monthly shipment amounts for the Galaxy A5 change in the ONLINE channel in 2024?
- How many units did we sell for each product group in South 3 during 2023?
- Which 3 models had the highest sales revenue for the 20 K - 30 K price range in North 1 during Q3 2024?
- What's the average daily counter sales volume for Note PCs in the Online channel for 2023?
- How did monthly sales revenues change for accessories in South 2 for 2024?
- How many units did each competitor sell in each channel in North 3 during November 2023?
- How did quarterly shipment quantities for the EF-CG920F model change in East 2 during 2024?
- What's the average weekly sales revenue for the Galaxy S20 FE in the GT channel in February 2024?
- How many units did each competitor sell in West 4 during Q2 2024?
- How did monthly shipment amounts for the Galaxy Z Fold 3 change in the B2B channel in 2023?
- How many units did we sell for each product group in South 1 during 2024?
- What's the market share of each competitor in the MT channel in sales of the Galaxy Note 9 in August 2024?
- Which 5 regions had the highest sales revenue for the R800N in Q3 2023?
- What's the average daily sales revenue for the EF-CN910P in East 1 for April 2024?
- Which month had the highest market share in sales volume for the MT channel in North 4 during 2023?
- How did weekly sales revenues change for tablets in South 3 during September 2024?
- How much did each competitor contribute to the quarterly sales revenue for East 2 during 2024?
- How did daily sales volumes change for the Galaxy Note 9 in the MT channel in North 2 during 2023?
- How many units did we ship and sell by month for the 15 K-20 K price range in West 3 during 2024?
- Which 3 models had the highest sales revenue for each price range in East 1 during Q1 2023?
- How did monthly sales revenues change for North 4 for each competitor during 2024?
- What's the yearly cumulative sales volume for accessories in the ONLINE channel for 2023?
- Which 5 regions had the highest average sales revenue for the EF-CG935 in Q2 2024?
- What were the monthly sales volumes for the Galaxy Watch4 series in West 1 during 2023?
- What's Samsung’s market share in sales revenue for the MT channel in Central during 2024?
- How did weekly shipment amounts change for tablets in the Online channel during Q3 2024?
- What's the market share of each price band in shipment value for the Galaxy F Fold 4 in East 1 during 2023?
- How much did we sell daily for the GT channel by product group in North 3 during December 2024?
- What were the quarterly sales volumes for the EF-NG930 model in the B2B channel during 2023?
- How much did each region sell monthly for accessories during 2023?
- Which 5 models had the highest sales volume in East 2 for the 30 K - 40 K price range during June 2024?
- What's the average weekly shipment amount for the GT channel in South 1 during November 2024?
- How much did monthly sales revenues change for the R970FD in the GT channel during 2023?
These questions are designed to be clear and straightforward, focusing on practical insights and business metrics that non-technical stakeholders can easily understand.