Empowering coders, one solution at a time
Empowering coders, one solution at a time
Cognizant is hiring fresher candidate for the role of software engineer. The details of the job , requirement and other information given below: Cognizant : Junior data analyst Qualification Graduate/Post Graduate/ Doctorate degree in life sciences/Pharmacy/Medical sciences/Registered Nurse Skills associated…
1. Create a view named ‘building_details’ to display all the details of building. 2. Create a view named ‘building_owners’ to display all the owners of the building. 3. Create a view named ‘owner_details’ to display the owner name and contact number of the buildings having length of the owner name greater than 15. 4.…
Write a query to change the due_date ‘2018-01-01’ to ‘2018-01-09’ in the bill table.
Write a query to display the second maximum payable amount who paid by the owner .Give an alias name to the second maximum payable amount as ‘second_max_payable_amount‘. Output: SECOND_MAX_PAYABLE_AMOUNT 724500
Write a query to display the second minimum fine amount from bill.Give an alias name to the second minimum fine amount as ‘second_min_fine_amount’. Output: SECOND_MIN_FINE_AMOUNT 472.5