Good day everyone. I'm learning how to use SQL to query databases but I have been experiencing different kinds of problems. It seems Bigquery limits what you can do if you ain't a paid user and MySQL will not import my data. Now I found Microsoft SQL server and I have been able to import my data.

The problem I am facing now is with querying each column or filtering for relevant information. Other than the fact that I can query the entire table, there is nothing else I can do with the new DBMS

I'm trying to replicate "Alex the analyst" SQL project but my table looks totally different from what he has. What am I doing wrong?
Someone should please help.

I'll advice you revise your knowledge on SQL.

First off, SQL Server supports both Transact-SQL ( its native dialect ) and SQL. Which are you using ?

If you're trying to query specific data, then you should be adding WHERE clause to your query e.g WHERE id = xyz.

Which bigquery are referring to?

I know bigquery is a data warehousing service on the Google cloud under analytics and co

wane01:


I'll advice you revise your knowledge on SQL.

First off, SQL Server supports both Transact-SQL ( its native dialect ) and SQL. Which are you using ?

Which bigquery are referring to?

Thank you for commenting. I'm a new guy here. I really do not know much about the differences between TRANSACT-SQL and SQL itself. And I am referring to Google Cloud's Big Query. I guess you have to pay to enjoy its full benefits.

I managed to resolve the problem. The structure of the excel file I uploaded might be the reason for the errors I experienced earlier. Now when I saved on google sheet, the errors seem to have vanished.

Can I have your support for my SQL needs, please?