mirror of
https://github.com/open-metadata/OpenMetadata.git
synced 2025-07-11 19:20:18 +00:00
ebfbd39cc2
* Fix metadata usage listing of tables * Fix #624: Ingestion: Fix REST API calls to get service and create service
957 lines
139 KiB
Plaintext
957 lines
139 KiB
Plaintext
query, database
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product_variant.product_id, dim_product_variant.title, dim_product_variant.barcode, dim_product.vendor from dim_product left join dim_product_variant on dim_product_variant.product_id=dim_product.product_id","shopify"
|
|
"select dim_product_variant.product_id, dim_shop.shop_id, dim_shop.name from dim_shop join dim_product_variant on dim_shop.shop_id = dim_product_variant.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_product.title from fact_line join dim_product on fact_line.product_id=dim_product.product_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.total_order_value from dim_customer join fact_order on dim_customer.shop_id=fact_order.shop_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product_variant.product_id, dim_product_variant.title, dim_product_variant.barcode, dim_product.vendor from dim_product left join dim_product_variant on dim_product_variant.product_id=dim_product.product_id","shopify"
|
|
"select dim_product_variant.product_id, dim_shop.shop_id, dim_shop.name from dim_shop join dim_product_variant on dim_shop.shop_id = dim_product_variant.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_product.title from fact_line join dim_product on fact_line.product_id=dim_product.product_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.total_order_value from dim_customer join fact_order on dim_customer.shop_id=fact_order.shop_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product_variant.product_id, dim_product_variant.title, dim_product_variant.barcode, dim_product.vendor from dim_product left join dim_product_variant on dim_product_variant.product_id=dim_product.product_id","shopify"
|
|
"select dim_product_variant.product_id, dim_shop.shop_id, dim_shop.name from dim_shop join dim_product_variant on dim_shop.shop_id = dim_product_variant.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_product.title from fact_line join dim_product on fact_line.product_id=dim_product.product_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.total_order_value from dim_customer join fact_order on dim_customer.shop_id=fact_order.shop_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product_variant.product_id, dim_product_variant.title, dim_product_variant.barcode, dim_product.vendor from dim_product left join dim_product_variant on dim_product_variant.product_id=dim_product.product_id","shopify"
|
|
"select dim_product_variant.product_id, dim_shop.shop_id, dim_shop.name from dim_shop join dim_product_variant on dim_shop.shop_id = dim_product_variant.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_product.title from fact_line join dim_product on fact_line.product_id=dim_product.product_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.total_order_value from dim_customer join fact_order on dim_customer.shop_id=fact_order.shop_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_location.name as location_name, dim_shop.name as shop_name from dim_location left join dim_location.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product_variant.product_id, dim_product_variant.title, dim_product_variant.barcode, dim_product.vendor from dim_product left join dim_product_variant on dim_product_variant.product_id=dim_product.product_id","shopify"
|
|
"select dim_product_variant.product_id, dim_shop.shop_id, dim_shop.name from dim_shop join dim_product_variant on dim_shop.shop_id = dim_product_variant.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_product.title, dim_product.vendor, dim_product.shop_id from dim_product left join dim_product.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_customer.customer_id, dim_customer.total_order_count, dim_customer.total_order_value from dim_customer left
|
|
join dim_shop on dim_customer.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_address.address_id, dim_address.shop_id, dim_address.first_name,dim_address.last_name, dim_shop.name
|
|
from dim_address left join dim_shop on dim_address.shop_id = dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select dim_staff.user_id,dim_staff.first_name, dim_staff.last_name, dim_shop.shop_id from dim_staff join dim_shop on
|
|
dim_staff.shop_id=dim_shop.shop_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, fact_line.price,fact_order.name, fact_order.total_price from fact_line join fact_order on fact_line.order_id=fact_order.order_id", "shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_shop.name from fact_line join dim_shop on fact_line.shop_id=dim_shop.shop_id","shopify"
|
|
"select fact_line.product_title, dim_product.title from fact_line join dim_product on fact_line.product_id=dim_product.product_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select dim_api_client.title, fact_order.location_id from dim_api_client join fact_order on dim_api_client.api_client_id=fact_order.api_client_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.first_name,dim_customer.last_name, dim_customer.city from dim_customer join fact_order on dim_customer.customer_id=fact_order.customer_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_customer.total_order_value from dim_customer join fact_order on dim_customer.shop_id=fact_order.shop_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_order.name, fact_order.total_price, dim_staff.email from fact_order join dim_staff on fact_order.user_id=dim_staff.user_id","shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, fact_sale.total_sale, fact_sale.shipping, dim_address.city from fact_sale join dim_address on fact_sale.billing_address_id=dim_address.address_id", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.gross_sales, dim_api_client.title, dim_api_client.api_client_id from fact_sale join dim_api_client on fact_sale.api_client_id=dim_api_client.api_client_id group by dim_api_clientid", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.returns, fact_sale.discounts, dim_customer.first_name, dim_customer.last_name, dim_customer.email from dim_customer join fact_sale on dim_customer.customer_id=fact_sale.customer_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, fact_line_item.name, fact_line_item.product_title, fac_line_item.quantity form fact_sale join fact_line_item on fact_sale.line_item_id=fact_line_item.line_item_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, dim_location.name from fact_sale join dim_location on fact_sale.location_id=dim_location.location_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sales, fact_order.location_id from fact_sale join fact_order on fact_sale.order_id=fact_order.order_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product.title, dim_product.product_id from fact_sale join dim_product on fact_sale.product_id=dim_product.product_id group by product_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.total_sale, dim_product_variant.sku, dim_product_variant.price from fact_sale join dim_product_variant on fact_sale.product_variant_id=dim_product.product_variant_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_address.city from fact_sale join dim_address on fact_sale.shipping_address_id=dim_address.shipping_address_id group by dim_address.city", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_shop.name, dim_shop.shop_id from fact_sale join dim_shop on fact_sale.shop_id = dim_shop.shop_id group by dim_shop.shop_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
"select fact_sale.gross_sale, dim_staff.first_name, dim_staff.last_name from fact_sale join dim_staff on fact_sale.user_id = dim_staff.user_id", "shopify"
|
|
|
|
|
|
|
|
|
|
|