There are 2 Tables: user_financial_detail, transaction_log. If the user is overdrawn by more than the credit limit, return 'YES' in this column. The credit_limit_breached column should contain either 'YES' or 'NO'. Build skills-based coding tests with tech problems a developer would encounter on the job and hire the team behind your next big idea. Write a query that prints this information for all the users present in the table user_finincial_detail in the following format: name | vpa | current_balance | credit_limit_breached Start free trial Focus on what really matters: the code. VWB wants to find out the current balance of all the users who have ever transacted and check whether they have breached their credit limit. The VWB records all such transactions in the table transaction_log, storing information such as the sender's vpa, receipient's vpa and the amount transferred. In this version I am solving the problem with a Subquery. It maintains its customer details like name, vpa and credit limit in the table user_financial_detail.Įach user can easily transfer money from his/her account to another VWB user's account by using his/her uniquely assigned vpa and receipt user's vpa. This video is solving the 'Contest Leaderboard' Problem on Hackerrank. ERROR 1064 (42000) at line 1: You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to. Virtual World Bank (VWB) helps its users in making online payments using virtual payment address (vpa). check the manual that corresponds to your MySQL server version for the right syntax to use near select CITY, length(CITY) from station order by. Coursera: Learn SQL Basics for Data Science.edureka: SQL Essentials Training & Certification.Udemy: SQL - MySQL for Data Analytics and Business Intelligence More than 3,000 tech teams, representing all industries and from countries around the world, trust HackerRank. Join over 16 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |