'BigQuery SQL - Merchant Center Transfer

I am running into an issue with writing an SQL query with Google Big Query. Basically looking to transfer the top products, per country, per category which are also in stock into a table.

So far I have pulled in the top products, per country, per category but the issue is with getting the 'in-stock' part added to the table. I can't find any similar keys in the schema to match them up.

Ideally the table would include:

Rank, Product Title, Country, Category, In-Stock

I would really appreciate any help on this! Thanks.

sqlgoogle-bigquerygoogle-merchant-center


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions