Troubleshooting Common SQL Errors with BigQuery

[parrotking]

good day community, during this lab at the first checkpoint, it keeps telling me to add column after the last sql query. dont know what im doing wrong

lab  : 

Derive Insights from BigQuery Data

[Naryi · Accepted solution]

Task 1. Pin a project to the BigQuery resource tree
Click Navigation menuNavigation menu icon > BigQuery.
2. Click + Add

Task 2. Find the total number of customers who went through checkout :
Copy the below code and click on Run:

#standardSQL
SELECT FROM `data-to-inghts.ecommerce.rev_transactions` LIMIT 1000

3. Copy the below code and click on Run:



#standardSQL
SELECT * FROM [data-to-insights:ecommerce.rev_transactions] LIMIT 1000

What's wrong with the new previous query to view 1000 items?
checkWe are using legacy SQL


4.Copy the below code and click on Run:


#standardSQL
SELECT FROM `data-to-insights.ecommerce.rev_transactions`

5.Copy the below code and click on Run:

#standardSQL
SELECT
fullVisitorId
FROM `data-to-insights.ecommerce.rev_transactions`

6.Copy the below code and click on Run:

#standardSQL
SELECT fullVisitorId hits_page_pageTitle
FROM `data-to-insights.ecommerce.rev_transactions` LIMIT 1000

How many columns will the previous query return?
check1, a column named hits_page_pageTitle


7.Copy the below code and click on Run:

#standardSQL
SELECT
fullVisitorId
, hits_page_pageTitle
FROM `data-to-insights.ecommerce.rev_transactions` LIMIT 1000

8.Copy the below code and click on Run:

#standardSQL
SELECT
fullVisitorId
, hits_page_pageTitle
FROM `data-to-insights.ecommerce.rev_transactions` LIMIT 1000

9. Copy the below code and click on Run:

#standardSQL
SELECT
COUNT(fullVisitorId) AS visitor_count
, hits_page_pageTitle
FROM `data-to-insights.ecommerce.rev_transactions`

10. Copy the below code and click on Run:

#standardSQL
SELECT
COUNT(DISTINCT fullVisitorId) AS visitor_count
, hits_page_pageTitle
FROM `data-to-insights.ecommerce.rev_transactions`
GROUP BY hits_page_pageTitle

11. Copy the below code and click on Run:


#standardSQL
SELECT
COUNT(DISTINCT fullVisitorId) AS visitor_count
, hits_page_pageTitle
FROM `data-to-insights.ecommerce.rev_transactions`
WHERE hits_page_pageTitle = "Checkout Confirmation"
GROUP BY hits_page_pageTitle

Click Check my progress to verify the objective.

[Yogi2703]

did you solve the problem? please help me also? send a email on (PII Removed by Staff)

[Naryi]

I have also this problem during the lab Troubleshooting Common SQL Errors

[Naryi · Accepted solution]

Task 1. Pin a project to the BigQuery resource tree
Click Navigation menuNavigation menu icon > BigQuery.
2. Click + Add

Task 2. Find the total number of customers who went through checkout :
Copy the below code and click on Run:

#standardSQL
SELECT FROM `data-to-inghts.ecommerce.rev_transactions` LIMIT 1000

3. Copy the below code and click on Run:



#standardSQL
SELECT * FROM [data-to-insights:ecommerce.rev_transactions] LIMIT 1000

What's wrong with the new previous query to view 1000 items?
checkWe are using legacy SQL


4.Copy the below code and click on Run:


#standardSQL
SELECT FROM `data-to-insights.ecommerce.rev_transactions`

5.Copy the below code and click on Run:

#standardSQL
SELECT
fullVisitorId
FROM `data-to-insights.ecommerce.rev_transactions`

6.Copy the below code and click on Run:

#standardSQL
SELECT fullVisitorId hits_page_pageTitle
FROM `data-to-insights.ecommerce.rev_transactions` LIMIT 1000

How many columns will the previous query return?
check1, a column named hits_page_pageTitle


7.Copy the below code and click on Run:

#standardSQL
SELECT
fullVisitorId
, hits_page_pageTitle
FROM `data-to-insights.ecommerce.rev_transactions` LIMIT 1000

8.Copy the below code and click on Run:

#standardSQL
SELECT
fullVisitorId
, hits_page_pageTitle
FROM `data-to-insights.ecommerce.rev_transactions` LIMIT 1000

9. Copy the below code and click on Run:

#standardSQL
SELECT
COUNT(fullVisitorId) AS visitor_count
, hits_page_pageTitle
FROM `data-to-insights.ecommerce.rev_transactions`

10. Copy the below code and click on Run:

#standardSQL
SELECT
COUNT(DISTINCT fullVisitorId) AS visitor_count
, hits_page_pageTitle
FROM `data-to-insights.ecommerce.rev_transactions`
GROUP BY hits_page_pageTitle

11. Copy the below code and click on Run:


#standardSQL
SELECT
COUNT(DISTINCT fullVisitorId) AS visitor_count
, hits_page_pageTitle
FROM `data-to-insights.ecommerce.rev_transactions`
WHERE hits_page_pageTitle = "Checkout Confirmation"
GROUP BY hits_page_pageTitle

Click Check my progress to verify the objective.

[czambran · Accepted solution]

Not sure what I missed but your instructions helped me get credit