Very few of us have a solid understanding of SQL. It is unrealistic to expect Users to sit down with an SQL text editor and write the following without error: SELECT"census"."ee_id" AS census_ee_id, "census"."dob" AS dob, "v_cens_comp"."mnth_wage" AS mnth_wage, "b_yr"."bp_1r" AS bp_1r, "b_yr"."bp_2r" AS bp_2r, (least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) AS r1, +((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) AS r2, (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15) AS r3, round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)) AS pia, "b_yr"."cum_cpi" AS cum_cpi, "b_yr"."ful_txt" AS ful_txt, "b_yr"."red_fact_65" AS red_fact_65, round((round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)))*"b_yr"."cum_cpi"*"b_yr"."red_fact_65") AS ret_at_65_mo, (round((round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)))*"b_yr"."red_fact_65"))*12 AS ann_ss, round((round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)))*"b_yr"."red_fact_65")/"v_cens_comp"."mnth_wage" AS ss_rep_pct, to_char((round((round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)))*"b_yr"."red_fact_65"))*12, '$fm99G999') AS ann_ss_t, to_char(100*round((round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)))*"b_yr"."red_fact_65")/"v_cens_comp"."mnth_wage", 'fm999%') AS ss_rep_pct_t, round(((round((least("v_cens_comp"."mnth_wage","b_yr"."bp_1r")*.9) + ((least("v_cens_comp"."mnth_wage","b_yr"."bp_2r")- least("v_cens_comp"."mnth_wage","b_yr"."bp_1r"))*.32) + (greatest(least("v_cens_comp"."mnth_wage","b_yr"."max_cvred_mo") -"b_yr"."bp_2r",0)*.15)))*"b_yr"."cum_cpi"*"b_yr"."red_fact_65")*(1+("b_yr"."del_ret_cr_pct"*5))) AS ret_at_70_mo FROM "rrdonnelley"."census" LEFT JOIN "rrdonnelley"."v_cens_comp" ON "census"."ee_id" = "v_cens_comp"."census_ee_id" LEFT JOIN "rrdonnelley"."b_yr" ON "v_cens_comp"."yob" = "b_yr"."y" ORDER BY dob ASC
Which is why we developed a Visual Query GUI that auto generated the code above. This does NOT mean that knowing SQL is not helpful. It does mean that simple queries can be created by a Novice with a nominal amount of training.
Select New .....Query from the horizontal menu. This will take you to Step 1 of the Query Editor. Give your new Query a Name and description, then click 'Next'.
The process of retrieving or the command to retrieve data from a database is called a query. Ask a question .. get an answer, but ... you must ask the correct question.
New Query
The GUI is designed specifically to allow HR to 'ask questions' (query) without any knowledge of SQL. This means your HR Team will be able to redo queries and as you do, you will learn more and more about SQL. Most of us learn best when we roll up our sleeves and try, regardless of the task, so give it a go. In addition, there is a an immense amount of material on the web.