Can someone please tell me what I am doing wrong, I am beyond frustrated

<PLEASE USE THIS TEMPLATE TO HELP YOU CREATE A GREAT POST!>

<Below this line, add a link to the EXACT exercise that you are stuck at.>
https://www.codecademy.com/en/courses/sql-table-transformation/lessons/date-number-string-functions/exercises/date-number-string-functions?action=lesson_resume&link_content_target=interstitial_lesson

<Below this line, in what way does your code behave incorrectly? Include ALL error messages.>
Error: near line 1: near “*”: syntax error
<In this course, it often helps to include a screenshot of your whole web browser – that lets everyone see what you see. If you wish to include a screenshot, add it below this line.>

<If you wish to copy/paste in your code, you can use this next section. This will allow others to copy/paste your code for testing – something that they won’t be able to do with just a screenshot.>SELECT (*) FROM bakeries LIMIT 10;

```

Replace this line with your code.

<do not remove the three backticks above>

why do you use parentheses around *? You shouldn’t, it causes the error

thank you, how am I supposed to know when to use it or not?

That is why you do the course? To learn how and when to use them. My sql knowledge isn’t that good, I just knew you shouldn’t use them like you did here.

Hi Williammunny1870,

Basically what you did is a common error when learning SQL.

What you have to know is that the parenthesis are generally used with functions to precise the argument of the function (i.e SELECT COUNT (*) FROM table ; will count the number of data/rows that you have in your table).

Hope this helps you avoid the confusion :wink:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.