Question

One company can have one or many offers One offer has a number of jobs

So: companies <= offers <= numJobs

SELECT Count(t_offer.fkCompany) AS companies, 
       Count(t_offer.id) AS offers, 
       Sum(t_offer.nJobs) AS numJobs
FROM t_offer

例如:

idOFFER    fkCOMPANY     numJOBS
   1           1            1
   2           3            2
   3           8            1
   4           1            2

问题是:

companies(3) <= offer(4) <=numJobs(6)

but the result is:

companies(4) <= offers(4) <= numJobs(6)

www.un.org/spanish/ecosoc 这样做的唯一途径是回答不止一次的问题?

Answer 1

我假定你想要的是disnico公司?

SELECT Count(DISTINCT t_offer.fkCompany) AS companies, 
       Count(t_offer.id) AS offers, 
       Sum(t_offer.nJobs) AS numJobs
FROM t_offer

友情链接