Write a MySQL query to get the names (firstname, lastname), Fee, Scholarship of all the student (Scholarship is calculated as 15% of Admission Fee)

Introduction

Write a MySQL query to get the names (firstname, lastname), Fee, Scholarship of all the student (Scholarship is calculated as 15% of Admission Fee). I have used phpMyAdmin for the following example.

Kindle Paperwhite High Resolution Display Tablet | Rs. 9999

- 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, admission_fee * .15 Scholarship
FROM students

Result

     

21 December 2018 3064       Written By: Rohit