SELECT c.customer_name, ROUND(SUM(i.total_price), 6)
FROM customer c
INNER JOIN invoice i ON c.id=i.customer_id
GROUP BY c.customer_name
HAVING SUM(i.total_price)<0.25*(SELECT AVG(total_price) FROM invoice)
ORDER BY ROUND(SUM(i.total_price), 6) DESC
Subscribe to:
Post Comments (Atom)
Popular Posts
-
SET NOCOUNT ON; WITH hours_worked as ( SELECT emp_id, CASE WHEN datepart(minute,TIMESTAMP) >= datepart(minute,l... -
select c.algorithm, q1.tot, q2.tot, q3.tot, q4.tot from coins c join (select sum(volume) as tot,coins.algorithm from transactions left joi... -
SELECT c.customer_name, ROUND ( SUM (i.total_price), 6 ) FROM customer c INNER JOIN invoice i ON c.id = i.customer_id GROUP BY ... -
You are updating the username policy on your company's internal networking platform. According to the policy, a username is considered...
-
The Calendar class is an abstract class that provides methods for converting between a specific instant in time and a set of calendar ...
-
Jack and Daniel are friends. Both of them like letters, especially uppercase ones. They are cutting uppercase letters from newspapers, and...
-
Write a class called MyRegex which will contain a string pattern. You need to write a regular expression and assign it to the pattern such...
-
We use the integers , , and to create the following series: You are given queries in the form of , , and . For each query, pr...
-
import math import os import random import re import sys from collections import defaultdict # # Complete the 'countPairs'... -
/*Java's System.out.printf function can be used to print formatted output. The purpose of this exercise is to test your understanding o...
No comments:
Post a Comment