Multiple Column Operations
sql
1SELECT name,
2 age + marks AS combined,
3 (age * 2) + marks AS weighted
4FROM students;Complex Calculations
sql
1SELECT name,
2 marks / 100.0 * 10 AS percentage
3FROM students;
1SELECT name,
2 age + marks AS combined,
3 (age * 2) + marks AS weighted
4FROM students;1SELECT name,
2 marks / 100.0 * 10 AS percentage
3FROM students;