Tech Study

Write a query to display the Full name, Branch, and fee for all students whose branch id is 200 and 500, and whose fee is not equal to 10,000, 14,000, 23000

Introduction

Write a query to display the Full name, Branch, and fee for all students whose branch id is 200 and 500, and whose fee is not equal to 10,000, 14,000, 23000

The following exercise will help you to improve your SQLite query skills effectively. I have used DB Browser for sqlite for following exercise.

student_id first_name last_name email mobile_number admission_date admission_fee branch branch_id
1. Mike Brown mike@example.com 875695632 12-06-2013 15000 Computer Science 100
2 Chris Lee chris@example.com 789652369 05-06-2012 18000 Computer Science 100
3 David Jones David@example.com 965412369 01-07-2013 14000 Mechanical Engineering 200
4 Michael Johnson Michael@example.com 845632136 22-08-2014 25000 Mechanical Engineering 200
5 Tom Cruise Tom@example.com 789563245 09-06-2013 15000 Civil Engineering 300
6 Mary Smith mary@example.com 846523698 10-07-2014 23000 Electrical engineering 400
7 James Johnson james@example.com 896523145 11-02-2015 25000 Chemical engineering 600
8 Robert Smith robert@example.com 984562368 25-06-2013 22000 Information technology 500
9 Maria Garcia maria@example.com 895641236 12-08-2012 14500 Civil Engineering 300
10 Brett Lee brett@example.com 756984562 20-06-2013 15000 Chemical engineering 600
11 James Anderson james@example.com 895621455 15-07-2018 35000 Information technology 500
12 Joe Root joe@example.com 985641236 22-08-2017 40000 Chemical engineering 600 
SELECT first_name, last_name, branch_id, admission_fee
FROM tbl_student
WHERE branch_id IN (200, 500)
AND admission_fee NOT IN (14000, 23000, 10000);

Result

Write a query to display the Full name, Branch, and fee for all students whose branch id is 200 and 500, and whose fee is not equal to 10,000, 14,000, 23000
Write a query to display the Full name, Branch, and fee for all students whose branch id is 200 and 500, and whose fee is not equal to 10,000, 14,000, 23000

Tagged0001423000and fee for all students whose branch id is 200 and 500and whose fee is not equal to 10BranchWrite a query to display the full name

C String Functions

C String Functions perform certain operations, It provides many useful string functions which can come into action. The <string.h> header …

Read more

Function Pointer in C++

Introduction : Function Pointer in C++ Pointers: In function pointer in c++ are the variables that consist of addresses of …

Read more