This is field
This is the statement I wrote
The select a.c hannel, b. o
The from chb_order_form a
The join
(
Select the channel, finish_time - order_time xsl-fo
The from chb_order_form
B)
On a.c hannel=biggest hannel
Group by a.c hannel;
An error
FAILED: SemanticException [Error 10025] : Line 1:17 Expression not in GROUP BY key 'fo'

CodePudding user response:

There are still problems
The select a.c hannel, (b.s ft - b.s ot)/biggest ft
The from chb_order_form a
The join (
Select the channel cl, the sum (order_time) sot, sum (finish_time) SFT, count (finish_time) CFT is
The from chb_order_form
Group by channel) b
On a.c hannel=biggest l
Group by a.c hannel;

CodePudding user response:

The select biggest, l (b.s ft - b.s ot)/biggest ft
The from (
Select the channel cl, the sum (order_time) sot, sum (finish_time) SFT, count (finish_time) CFT is
The from chb_order_form
B group by channel);

CodePudding user response:

What do you want to express?