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 vote159 views1 answer
Sql dmv to capture updates
SQL
7 votes158 views5 answers
Show details of table postgres
SQL
1 vote139 views1 answer
Jooq convert using gbk
SQL
0 vote158 views1 answer
Amount of entries in a table psql
SQL
2 votes154 views2 answers
Mysql get time from datetime
SQL
3 votes204 views1 answer
Oracle function
SQL
1 vote259 views1 answer
Oracle current sequence value
SQL
4 votes163 views2 answers
How to insert ip address in mysql using php
SQL
0 vote161 views2 answers
How covert into int in maria db
SQL
0 vote163 views1 answer
Postgres can integer fields be negative
SQL