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 vote298 views1 answer
Check connections to database postgres
SQL
0 vote273 views1 answer
Mysql function variable
SQL
1 vote301 views1 answer
Oracle difference between two dates in years
SQL
1 vote312 views1 answer
Database Queries
SQL
7 votes283 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
6 votes326 views3 answers
Psql show columns of table
SQL
4 votes299 views2 answers
Installing sql on ubuntu
SQL
0 vote287 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote275 views3 answers
Drop multiple columns in sql
SQL
1 vote273 views1 answer
Oracle sql create or replace view
SQL