SQL server query column yes or no

SELECT  a.ID, a.FirstName, a.Lastname,
        CASE WHEN COUNT(b.CustID) > 0 THEN 'YES' ELSE 'NO' END AS HasOrders
FROM    Customer a
        LEFT JOIN Orders b
            ON a.ID = b.CustID        -- <<== the linking column on both tables
GROUP   BY a.ID, a.FirstName, a.Lastname

Similar codes

2 votes237 views1 answer
Brew start postgres manual
SQL
0 vote233 views1 answer
Oracle exchange partition
SQL
2 votes248 views3 answers
Current setting postgres timezone
SQL
0 vote241 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
1 vote235 views1 answer
Pv mysql import
SQL
2 votes249 views1 answer
Oracle insert or update
SQL
0 vote246 views1 answer
Name '_mysql' is not defined
SQL
1 vote216 views3 answers
Mysql Server Start
SQL
2 votes414 views1 answer
Oracle virtual column
SQL
4 votes238 views1 answer
Oracle session date format
SQL