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