lbwavebo/text2sql

1question,context,sql2Give me total company gross bookings in March 2023,"rate type not specified, so use 'USD'. Version not specified, since it is not current month, use 'Actuals'",select sum(gross_bookings) from secure_finance_staging.fds_product_datamart where calendaryear=2023 and calendarmonth=3 and version='Actuals'and rate_type='USD'3What is NETR for lob_1001 in March 2023?,"rate type not specified, so use 'USD'. Version not specified, since it is not current month, use 'Actuals'",select sum(netr) from secure_finance_staging.fds_product_datamart where calendaryear=2023 and calendarmonth=3 and version='Actuals'and rate_type='USD' and lob_code = '1001'4What were gross bookings in New York last week for lob_1001?,"rate type not specified, so use 'USD'. ",SELECT sum(gross_bookings)  FROM secure_finance_staging.fds_product_datamart  WHERE  version = 'Estimate' AND rate_type = 'USD'  AND lob_code = '1001' AND iso_weekofyear = (SELECT MAX(iso_weekofyear) - 1 FROM secure_finance_staging.fds_product_datamart) and city_name = 'New York City'5"How much did The lob_1001 mobility business spend on Trip Insurance In March'23, plan rate."," Version not specified, since it is not current month, use 'Actuals'. US = Country - United States.","SELECT sum(trip_insurance) 6FROM secure_finance_staging.fds_product_datamart 7WHERE  version = 'Actuals'8AND rate_type = 'Plan Rate' 9AND lob_code = '1001'10AND country_name = 'Country - United States'11and calendaryear=202312and calendarmonth=3"13Please provide U4B GBs and completed trips in San Francisco last month for lob_1001 using plan rate,"Version not specified, since it is not current month, use 'Actuals'. ","SELECT sum(trip_insurance) 14FROM secure_finance_staging.fds_product_datamart 15WHERE  version = 'Actuals'16AND rate_type = 'Plan Rate' 17AND lob_code = '1001'18AND city_name = 'San Francisco'19and is_u4b=TRUE20and calendarmonth=321and calendaryear=2023"22What was subs pass revenue in 2023/03 grouped by lob_code?,"rate type not specified, so use 'USD'. Version not specified, since it is not current month, use 'Actuals'","SELECT lob_code, sum(subscription_pass_revenue) 23FROM secure_finance_staging.fds_product_datamart 24WHERE  version = 'Actuals'25AND rate_type = 'USD' 26and calendarmonth=327and calendaryear=202328GROUP BY lob_code29order BY 2 desc"30What was adjusted EBITDA by fulfillment type in Australa in March 2023?,"rate type not specified, so use 'USD'. Version not specified, since it is not current month, use 'Actuals'","SELECT fulfillment_type, sum(adj_ebitda) 31FROM secure_finance_staging.fds_product_datamart 32WHERE  version = 'Actuals'33AND rate_type = 'USD' 34and calendarmonth=335and calendaryear=202336and country_name='Country - Australia'37GROUP BY fulfillment_type38order BY 2 desc"39Give me VC of all flowershops in march 2023,"rate type not specified, so use 'USD'. Version not specified, since it is not current month, use 'Actuals'. flowershop is a type of merchant_type","SELECT sum(variable_contribution) 40FROM secure_finance_staging.fds_product_datamart 41WHERE  version = 'Actuals'42AND rate_type = 'USD' 43and calendarmonth=344and calendaryear=202345and merchant_type_analytics='MERCHANT_TYPE_FLORIST'"46group has_membership gross_bookings = /N by lob_code for mar'23.,"rate type not specified, so use 'USD'. Version not specified, since it is not current month, use 'Actuals'","SELECT47lob_code,48sum(gross_bookings) as gross_bookings49FROM secure_finance_staging.fds_product_datamart 50WHERE  version = 'Actuals'51AND rate_type = 'USD' 52and calendarmonth=353and calendaryear=202354and has_membership IS NULL55group by lob_code56order by 2 desc"57Show me the the metric gross bookings and its children for connect in March of 2023 in plan rate,"Version not specified, since it is not current month, use 'Actuals'","SELECT sum(gross_bookings) as gross_bookings,58sum(fares_basket) as fares_basket,59sum(booking_eater_fees) as booking_eater_fees,60sum(taxes_collected) as taxes_collected61FROM secure_finance_staging.fds_product_datamart 62WHERE  version = 'Actuals'63AND rate_type = 'Plan Rate' 64and calendarmonth=365and calendaryear=202366and finance_product_name ='Connect'"67"Show me variable contrbution and its children for members vs non members in San Francisco for March, Plan rate","Version not specified, since it is not current month, use 'Actuals'","SELECT68has_membership,69sum(netr) as netr,70sum(variable_costs) as variable_costs,71sum(variable_contribution) as variable_contribution72FROM secure_finance_staging.fds_product_datamart 73WHERE  version = 'Actuals'74AND rate_type = 'Plan Rate' 75and calendarmonth=376and calendaryear=202377and city_name = ('San Francisco')78group by has_membership"79Which countries with gbs>10M in the month have the highest NETR as a % of gross bookings in march'23 for lob_2001?,"rate type not specified, so use 'USD'. Version not specified, since it is not current month, use 'Actuals'","SELECT80country_name,81sum(netr)/sum(gross_bookings) as netr_pct_gb82FROM secure_finance_staging.fds_product_datamart 83WHERE  version = 'Actuals'84AND rate_type = 'USD' 85and calendarmonth=386and calendaryear=202387and lob_code ='2001'88group by country_name89having sum(gross_bookings) > 1000000090order by 2 desc"91Show me gross bookings per trip for the cities in the United States with the highest gross bookings in March 2023 for lob_1001,"rate type not specified, so use 'USD'. Version not specified, since it is not current month, use 'Actuals'","SELECT92city_name,93sum(gross_bookings),94sum(gross_bookings)/sum(completed_trips) as gb_per_trip95FROM secure_finance_staging.fds_product_datamart 96WHERE  version = 'Actuals'97AND rate_type = 'USD' 98and calendarmonth=399and calendaryear=2023100and lob_code ='1001'101and country_name in ('Country - United States')102group by city_name103order by 2 desc"104What is insurance per mile by product name in in the United States for march'23?,"rate type not specified, so use 'USD'. Version not specified, since it is not current month, use 'Actuals'","SELECT105city_name,106sum(gross_bookings),107sum(gross_bookings)/sum(completed_trips) as gb_per_trip108FROM secure_finance_staging.fds_product_datamart 109WHERE  version = 'Actuals'110AND rate_type = 'USD' 111and calendarmonth=3112and calendaryear=2023113and lob_code ='1001'114and country_name in ('Country - United States')115group by city_name116order by 2 desc"117"Show me U4B vs non U4B  netr, variable_costs, and variable contribution as a percentage of gross bookings for ","rate type not specified, so use 'USD'. Version not specified, since it is not current month, use 'Actuals'","SELECT118is_airport,119sum(gross_bookings),120sum(netr)/sum(gross_bookings) as netr_pct_gb,121sum(variable_costs)/sum(gross_bookings) as varible_costs_pct_gb,122sum(variable_contribution)/sum(gross_bookings) as vc_pct_gb123FROM secure_finance_staging.fds_product_datamart 124WHERE  version = 'Actuals'125AND rate_type = 'USD' 126and calendarmonth=3127and calendaryear=2023128and lob_code ='1001'129and country_name in ('Country - United States')130group by is_airport131order by 2 desc"