mysql - AVG or SUM in SQL where the values are being calculated on the fly -


itemprop = "text">

I have an existing SQL query that gets call stats from a Zultys MX250 phone system: - 

  select concat (left (u.firstname, 1), name as left (u.lastname, 1)), sec_to_time (sum (time_to_sec (s.disconnecttimestamp) - time_to_sec (s.connecttimestamp)) ) As the period, join the session '#Calls' as COUNT (*) as s.ExtensionID1 = u.ExtensionId or s.ExtensionID2 = u.ExtensionId on mxuser u where s.ServiceExtension1 zero and s.connecttimestamp & Gt; = CURRENT_DATE and binary u.userprofilename = Binary 'DBAM' group by U.Fastamen, U. Ostine '# Call' by DESC, DESC Duration;

The output is as follows: - 

 Name Period # hour went 01:19:10 30 AS 00:44:59 28 EW 00:51:13 22 SH 00:21:20 13 MG 00:12:04 8 TS 00:42:02 5 DS 00:00:12 1

I am trying to produce a fourth column which is average for each The call time shows the user, but how to figure out how.

Mathematically it is only struggling to see the "Duration" / "#Calls" "But after seeing some similar questions on StackOverflow, examples of questions are also simple to help me related

Right now, I do not even believe it is possible to split the column with the number of columns.

UPDATE : I was very close to my trial but all were confused and amp; More work here is the latest SQL (thanks to @ McAdam331 & my partner work gym): - 

  select concat (left (u.firstname, 1), left ( U.lastname, 1) duration, '#Calls' as COUNT (*), sec_to_time (sum (as time_to_sec (s.disconnecttimestamp) - time_to_sec (s - name, sec_to_time (time_to_sec (s.connecttimestamp)) Connect as much as the session (time_to_sec (s.disconnecttimestamp). ConnectTamstamp)) / / (*)) Join more sessions than sessions, Extensid 1 = U Extension ID or S. ExtensionID2 = U. Extension IDs where S. Service Extension 1 Zero and s.connecttimestamp> = CURRENT_DATE and Binary U.userprofilename = Binary 'DBAM' group by u.firstname, u.lastname ORDER by average DESC;

The output is as follows: - 

 Name Period # Call Average DS 00:14:25 4 00:03:36 MG 00:17:23 11 00: 01:34 ts 00:33:38 22 00:01:31 EW 01:04:31 43 00:01:30 AS 00:49:23 33 00:01:29 TH 00:43:57 35 00:01: 15 SH 00:13:51 12 00:01:09

OK, you can get it Number of seconds of total, as you do before changing it on time, why not take the total number of seconds, divide by the number of calls, and then by changing back to that time Not? 

  SELECT sec_to_time (SUM (time_to_sec (s.disconnecttimestamp) - time_to_sec (s) .connecttimestamp)) / COUNT (*)) As the average duration

Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more