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 vote125 views1 answer
Apt install sql server
SQL
0 vote119 views1 answer
Isnull in sqlite
SQL
4 votes118 views1 answer
Mysql insert from local csv
SQL
2 votes130 views1 answer
Mysql change data type of column
SQL
0 vote125 views1 answer
Sql period overlap
SQL
3 votes132 views3 answers
Raw select laravel
SQL
18 votes119 views2 answers
Sql inner join
SQL
5 votes133 views3 answers
Bash: mysql: command not found
SQL
0 vote111 views1 answer
How to drop a trigger in postgresql
SQL
0 vote128 views1 answer
Count columns psql(PostreSQL)
SQL