Tech Study

Write a MySQL query to display the firstname, lastname and fee for all students whose fee is not in the range 1000 through 1500

Introduction

Write a MySQL query to display the firstname, lastname and fee for all students whose fee is not in the range 1000 through 1500. I have used phpMyAdmin for the following example.

– students

StudentId FirstName LastName Admission_fee Admission_date Branch
1 John Smith 1000 2018-06-10 Computer Engineering
2 David Jones 1200 2018-06-20 Civil Engineering
3 Michael Johnson 900 2018-08-15 Chemical Engineering
4 Chris Lee 1500 2018-07-10 Electrical Engineering
5 Mike Brown 1600 2018-09-10 Mechanical Engineering
6 Lisa Smith 1800 2018-07-10 Computer Engineering
7 Mary Smith 1600 2018-06-11 Computer Engineering
SELECT firstname, lastname, admission_fee
FROM students
WHERE admission_fee NOT 
BETWEEN 1000 
AND 1500

Result

Write a MySQL query to display the firstname, lastname and fee for all students whose fee is not in the range 1000 through 1500
Write a MySQL query to display the firstname, lastname and fee for all students whose fee is not in the range 1000 through 1500

Taggedlastname and fee for all students whose fee is not in the range 1000 through 1500Write a MySQL query to display the firstname

Java Final keyword

Introduction : java final keyword The final keyword present in Java programming language is generally used for restricting the user. …

Read more

C++ Memory Management: new and delete

C++ Memory Management We know that arrays store contiguous and the same type of memory blocks, so memory is allocated …

Read more