SQL Questions: Product Management System

Problem Scenario:     A Dairy Milk Organization wants to develop a data base Product  Management System (PMS) which mai...

SQL Questions:Movies Management system

Movies Management system Set-1 1. Count the members who have gold cards. Ans: select count(ccd.customer_id) as Count fr...

SQL Questions:Loan Management system

Loan Management system 1.Write a query to display category and number of items in that category. Give the count an alias nam...

SQL Questions:Flight Management system-2 ( AIRLINES MANAGEMENT SYSTEM)

AIRLINES MANAGEMENT SYSTEM 1.Display profile id of passenger who booked minimum number of tickets. Ans:select profile_id...

SQL Questions:Flight Management system-1

Flight Management system-1 Q./* 1. Display passenger name who has a 'e' as second letter in their name*/ select...