In SQR, we use below select construct to retrieve data from database.
Now I need count of EE working in Department '10'. Below is the code to achieve this.
WHERE DEPARTMENT_ID = 10
Sometimes, by mistake we might use #Count_EE as column variable since the value of Count is numeric. So coming to basics, all column variables will be referred with & (Ampersand).