For the following SQL table, how could I go about writing a query that selects several entries based off of a particular attribute or set of attributes?

USE UNCLE_BOB_FIXIT GO

INSERT INTO Job (Job_Status, Job_Hours, Job_Uniqueness, Job_Start_Date, Job_End_Date, Job_Material_Cost, Job_Labor_Cost, Job_Extra_Cost, Job_Total_Cost, Address_ID, Customer_ID)

VALUES ('B', 5.0, 'none', '2018-01-15', '2018-01-15', 86.25, 50.00, 0.00, 136.25, 1, 1);

INSERT INTO Job (Job_Status, Job_Hours, Job_Uniqueness, Job_Start_Date, Job_End_Date, Job_Material_Cost, Job_Labor_Cost, Job_Extra_Cost, Job_Total_Cost, Address_ID, Customer_ID)

VALUES ('A', 3.25, 'customer has a dog', '2018-07-20', '2018-07-21', 30.00, 32.50, 5.00, 67.50, 2, 2);

INSERT INTO Job (Job_Status, Job_Hours, Job_Uniqueness, Job_Start_Date, Job_End_Date, Job_Material_Cost, Job_Labor_Cost, Job_Extra_Cost, Job_Total_Cost, Address_ID, Customer_ID)

VALUES ('R', 10.5, 'mornings only', '2018-09-01', '2018-09-05', 45.00, 105.00, 10.00, 160.00, 3, 3);