Cacher is the code snippet organizer for pro developers

---- Poziom stanowiska

SELECT count(1) as count, (case when cd_position = 0 then '-' when cd_position = 1 then 'Director' when cd_position = 2 then 'Manager' when cd_position = 3 then 'Specialist' when cd_position = 4 then 'Assistant' when cd_position = 5 then 'Intern' end) as position FROM `client_detail` group by `cd_position`;

---- Jezyki

SELECT l.languages_name_eng as language, count(cl.cl_id) as count FROM `client_lang` cl left join client c on cl.cl_client_id = c.client_id left join languages l on cl.cl_lang_id = l.languages_id group by cl.cl_lang_id;

---- Branże

SELECT i.industry_name as industry, count(1) as count FROM `client_to_industry` ci left join client c on ci.client_client_id = c.client_id left join industry i on ci.industry_industry_id = i.industry_id group by ci.industry_industry_id;

---- Do you live in Poland?

SELECT count(1) as count FROM `client_detail` WHERE `cd_live_in_poland` = 2;

---- I hereby give my consent to receive electronic commercial communication from MBE group Sp. z o.o.,  especially regarding the company’s marketing activities

SELECT count(1) as count FROM `client` WHERE `client_consent_mail_mbe` = 1;

---- I hereby give my consent to receive commercial communication from the partners of MBE group Sp. z o.o. (potential employers or entities acting on their behalf and others), especially regarding jobs in the financial sector or educational offers.

SELECT count(1) as count FROM `client` WHERE `client_consent_mail` = 1;