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

0 vote152 views1 answer
Oracle exchange subpartition
SQL
2 votes189 views1 answer
Sql missing records from another table
SQL
0 vote115 views1 answer
Mysql insert with foreign key
SQL
10 votes177 views2 answers
Select nextval from sequence oracle
SQL
3 votes149 views3 answers
Update join
SQL
0 vote151 views1 answer
Mysql beautifier terminla
SQL
0 vote155 views1 answer
Add super privilege mysql
SQL
-1 vote145 views1 answer
How to open blade file from blade in laravel
SQL
0 vote159 views1 answer
Postgresql list extensions
SQL
0 vote146 views3 answers
ChAnge TABLE name apex oracle
SQL