Write a query to display the number of travel cards having balance greater than or equal to 45. Give an alias name as max_balance_count.Note:1. Display only the number of travel cards having balance greater than or equal to 45 from travel_card table.2. Specify the alias name without any mistake.3. Specify condition on balance column of travel_card table.3. Compare your executed result with the sample output given below.Sample output:
Question
Write a query to display the number of travel cards having balance greater than or equal to 45. Give an alias name as max_balance_count.Note:1. Display only the number of travel cards having balance greater than or equal to 45 from travel_card table.2. Specify the alias name without any mistake.3. Specify condition on balance column of travel_card table.3. Compare your executed result with the sample output given below.Sample output:
Solution
The query you're looking for would look something like this:
SELECT COUNT(*) AS max_balance_count
FROM travel_card
WHERE balance >= 45;
Here's a step-by-step breakdown of what this query does:
-
SELECT COUNT(*) AS max_balance_count: This part of the query is selecting the count of all rows that meet the criteria specified in the WHERE clause. TheAS max_balance_countpart is giving this count an alias name ofmax_balance_count. -
FROM travel_card: This part of the query specifies the table that we're selecting data from, which in this case is thetravel_cardtable. -
WHERE balance >= 45: This is the condition that the rows must meet in order to be included in the count. In this case, we're only counting rows where thebalanceis greater than or equal to 45.
Similar Questions
Write a query to display the variance of balance from the travel_card table. Give an alias name as balance_variance.Note:1. Display only the variance of balance from travel_card table.2. Specify the alias name without any mistake.3. Compare your executed result with the sample output given below.Sample output:
Write a query to display the person name,contact number,balance,entry_time and exit_time details of all the persons who is having the second highest balance in their travel cards. Display the records in ascending order based on their person_name.Note:1. Display only the below 5 columns, i. person name ii. contact number iii. balance iv. entry time and v. exit timewith the condition having second highest balance.2. Order by is mandatory.3. Compare your executed result with the sample output given below.
Write a query to display the number of bills having fine_amount. Give an alias name as 'count_of_bills_with_fine'.Note:1. Display only the number of bills having the fine_amount from bill table. (If fine_amount is greater than 0 then it indicates that bill got fine_amount.)2. Specify the alias name without any mistake.3. Specify condition on fine_amount column of bill table.3. Compare your executed result with the sample output given below.Sample output:
Write a query to display the travel_card_id, entry_station_id and sum of amount received between the entry_time dates 21-Dec-2017 and 23-Dec-2017. Give an alias name as total_payment. Display the records sorted in ascending order based on the travel_card_id.
Write a query to display the person_name and the contact_number from travel_card table of every person whose destination station is on the route 'North East line' with the payment more than 25. Display the records in ascending order based on person name.Note:1. Display only the person_name and contact_number from the travel_card table whose travel_payment destination route North East line with amount >25.2. Tables involved are travel_card, travel_payment and station3. In travel_payment table, the exit_station_id must match with the station id with name ‘North East line’ and amount greater than 25.4. Order by is mandatory.5. Compare your executed result with the sample output given below.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.