Skip to main content

Mock 3 Slot3 - Handson - 21st July RDBMS (20 Marks) 1.2 Cars Rented on Same Day

 Write a query to display the details like Customer id, Customer name, Car id, Car name, pickup date and return date which has been taken for rent on the same day. Sort the result based on Customer id in ascending order.

Sample Output:

CUST_ID       CUST_NAME     CAR_ID      CAR_NAME       PICKUP_DATE      RETURN_DATE

      01                 John                V001           Hyundai            20-MAR-2018       20-MAR-2018

[Hint: Use Customers, Cars and Rentals table to retrieve records]

Write a query to display the details like Customer id, Customer name, Car id, Car name, pickup date and return date which has been taken for rent on the same day. Sort the result based on Customer id in ascending order. Sample Output: CUST_ID CUST_NAME CAR_ID CAR_NAME PICKUP_DATE RETURN_DATE 01 John V001 Hyundai 20-MAR-2018 20-MAR-2018 [Hint: Use Customers, Cars and Rentals table to retrieve records] Evaluation Result: Result Description Summary of tests:(Note:Your query is evaluated against different datasets. Kindly do not Hardcode) +------------------------------+ | 2 tests run / 2 test passed | +------------------------------+

Write a query to display the details like Customer id, Customer name, Car id, Car name, pickup date and return date which has been taken for rent on the same day. Sort the result based on Customer id in ascending order. Sample Output: CUST_ID CUST_NAME CAR_ID CAR_NAME PICKUP_DATE RETURN_DATE 01 John V001 Hyundai 20-MAR-2018 20-MAR-2018 [Hint: Use Customers, Cars and Rentals table to retrieve records] Evaluation Result: Result Description Summary of tests:(Note:Your query is evaluated against different datasets. Kindly do not Hardcode) +------------------------------+ | 2 tests run / 2 test passed | +------------------------------+


Evaluation Result:


 
Result Description
 Summary of tests:(Note:Your query is evaluated against different datasets. Kindly do not Hardcode)

+------------------------------+
| 2 tests run / 2 test passed  |
+------------------------------+
Labels:

Comments

Post a Comment

Popular posts from this blog

Classes and Objects | Accenture TFA

  Question  1 Correct Mark 1.00 out of 1.00 Flag question Question text ___ and _____ are the access specifiers that can be applied to top level Class. Select one or more: public   protected default   private Feedback Your answer is correct. The correct answers are: default, public Question  2 Correct Mark 1.00 out of 1.00 Flag question Question text class Sample{      private double num = 100;    private int square(int a){ return a*a;    } }   public class Test{    public static void main(String args[]){   Sample obj = new Sample();   System.out.println(obj.num);  System.out.println(obj.square(10));    }   } Select one: Compile time error   Run time error Executes but no output 100 Feedback Your answer is correct. The correct answer is: Compile time error Question  3 Correct Mark 1.00 out of 1.00 Flag question Question text Choose the ...
Post a Comment
Read more

UPSEE Counselling 2018 Round 3

UPSEE Counselling 2018 Round 3, AKTU/UPTU Counselling, Started – Register Here UPSEE 2018 Seat Allotment Result (Round 3)  is releasing on  13th July 2018 . It will be conducted through online mode. The university conducts a state level examination in name of Uttar Pradesh State Entrance Exam (UPSEE) for providing admission to the UG & PG courses in the field of engineering, management, etc.  You can get complete information about AKTU Counselling 2018. Here, we are providing details about the schedule, procedure, admission, etc. UPSEE Counselling 2018 –  Seat Allotment Round 2 Result on 10th July Exclusive:  UPSEE 2018 Seat Allotment Result (Round 3) is releasing on 17th July 2018.  Link will be provided here. UPSEE 2018 Counselling User Manual for candidates has been released now.   Click here to view user manual. Click here to view UPSEE 2018 Counselling schedule. Physical reporting will be started on 20th July....
3 comments
Read more

Spot Round

Never ever give up !!! “Life is a journey with up and downs” Feeling happy when everything is right is natural, but feeling sad for something gone wrong can’t be justified. Many say miracle doesn’t happen, but a miracle is something that doesn’t have logic… Do you believe in miracles? So, stop seeing logic everywhere and then you can feel miracles. I want to share something… During my counselling for Bachelor’s degree till last round, I was unable to get a seat in college I want to study in. It felt like everything has gone. Then I heard about Spot Round. I was not sure to secure a seat. But I went there to try my luck, in a hope of a miracle. So, I kept ready all my necessary documents made a DD for this round. While I was going to reporting centre my mind was full of the variety of thoughts. I made a mistake and I was little late for reporting. So, I rushed up through check-in and register myself for this special round. Then I went to a hall where everyone ...
10 comments
Read more