This section is not intended to be a course in the SQL language. Hence, the focus will be put on the minimal set of differences that you must know in order to write queries properly.

...

Expand
title Example
Code Block language sql SELECT 'This is a string' as `Column Alias` FROM DUAL `Table alias`

Table, column and function names are case sensitive

...

• Use Uppercase names

Expand
title Example
Code Block language sql select * from PROJECT will work. Whereas Code Block language sql select * from project will not. Image Modified

No schema names

Many database vendors group their tables into schemas (i.e.: PUBLIC). SQL Cloud does not support them.

...

SELECT `i`.`KEY`as `Issue`, count(*) as `Num. comments`
FROM ISSUE `i`
LEFT JOIN ISSUECOMMENT `ic` ON `ic`.`ISSUEID` = `i`.`ID`
WHERE `i`.`JQL` = 'PROJECT = TALH'
GROUP BY `i`.`KEY`
HAVING count(*) > 2

Works!

In this query the condition has been modified to uses column aliases: `Num. comments` > 2

SELECT `i`.`KEY`as `Issue`, count(*) as `Num. comments`
FROM ISSUE `i`
LEFT JOIN ISSUECOMMENT `ic` ON `ic`.`ISSUEID` = `i`.`ID`
WHERE `i`.`JQL` = 'PROJECT = TALH'
GROUP BY `i`.`KEY`
HAVING `Num. comments` > 2

Not works!