Correct table quoting
The SQL standard prescribes double quotes for quoted identifiers:

SELECT * FROM "tablename"


MySQL and SQL Server can be configured to comply with the standard, while other DBMSes comply out of the box. However, as others suggested in comments, you should avoid using quoted identifiers if possible, because it opens opportunities for bugs and unexpected behaviour in the SQL code.