Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Write separate query for each of the following. Strcmp Replace Length Concat Datediff Sysdate Curdate Date Year Month Abs Ceiling Floor Round

Write separate query for each of the following. Strcmp Replace Length Concat Datediff Sysdate Curdate Date Year Month Abs Ceiling Floor Round

Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter8: Arrays
Section: Chapter Questions
Problem 9RQ
See similar textbooks
icon
Related questions
Question

Create all the tables as shown in schema.

Import or execute the SQL statements given in data.sql.

Write SQL queries for the following statements. Submit screen shot of query and result.

 

 

  1. Show the name of movies which were released in both 2D and 3D. (Use Natural join)
  2. Show all customer names along with movie names they booked. Show all the customer names whether they booked any move or not. Also show all movie names whether they were booked by a customer or not. (Use Outer Join)
  3. Show movie names along with the total number seats that were booked for it. (Use Aggregate Function)
  4. Show category names along with the number of movies present in that category. (Use Aggregate Function)
  5. Show movie names which has a play time of more than 2 hours or they are in 3D.(Use set operations)
  6. Show staff names who live in ‘kharian’ but they have not done any booking as yet. (Use nesting)
  7. Show movies having same release dates.
  8. Show movie names which have got the maximum bookings.
  9. From the given database state, write sql queries of your own choice to observe behavior of following functions. Write separate query for each of the following.
    1. Strcmp
    2. Replace
    3. Length
    4. Concat
    5. Datediff
    6. Sysdate
    7. Curdate
    8. Date
    9. Year
    10. Month
    11. Abs
    12. Ceiling
    13. Floor
    14. Round

 

category screen CatD INT(11) CatName VARCHAR(25) SreeniD INT(11) OSreenName VARCHAR(25) screen_type v SreniD INT(11) Indexes P TypelD INT(1) Indexes Indexes movie_category O MovielD INT(11) O CatID INT(11) movie MovielD INT(11) O MName VARCHAR(S0) O Realease Date DATE |O Play_tim e INT(1) Indexes Indoxes screen_movie stype Screen_Movie_ID INT(11) te o sceening_Date DATE O Shift VAROHAR(25) O MovielD INT(11) OScreeniD INT(11) TypelD INT(11) O TName VARCHAR(2) Indexes mtype movie_type TypelD INT(11) O THame VAROHAR(2 Indexes TypelD INT(11) MovielD INT(11) booking Indexes staft Indexes | customer aD INT(11) o olame VAROHAR(25) O Caddress VARCHAR (50) BID INT (11) O No_of Seats INT( 1) |o saft Booking_Date DATE o Screen Movie D INT(11) o SID INT(1) SID INT(11) SName VAROHAR (25) O sDesignation VARCHAR(25) O Saddress VARCHAR(25) Indexes oaD INT(11) Indexes Indexes
Transcribed Image Text:category screen CatD INT(11) CatName VARCHAR(25) SreeniD INT(11) OSreenName VARCHAR(25) screen_type v SreniD INT(11) Indexes P TypelD INT(1) Indexes Indexes movie_category O MovielD INT(11) O CatID INT(11) movie MovielD INT(11) O MName VARCHAR(S0) O Realease Date DATE |O Play_tim e INT(1) Indexes Indoxes screen_movie stype Screen_Movie_ID INT(11) te o sceening_Date DATE O Shift VAROHAR(25) O MovielD INT(11) OScreeniD INT(11) TypelD INT(11) O TName VARCHAR(2) Indexes mtype movie_type TypelD INT(11) O THame VAROHAR(2 Indexes TypelD INT(11) MovielD INT(11) booking Indexes staft Indexes | customer aD INT(11) o olame VAROHAR(25) O Caddress VARCHAR (50) BID INT (11) O No_of Seats INT( 1) |o saft Booking_Date DATE o Screen Movie D INT(11) o SID INT(1) SID INT(11) SName VAROHAR (25) O sDesignation VARCHAR(25) O Saddress VARCHAR(25) Indexes oaD INT(11) Indexes Indexes
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Procedures in SQL
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS