Number of bytes deleted or added

This query is marked as a draft This query has been published by Ananth subray.
SQL

use mrwiki_p;
SELECT anon_1.rev_user AS anon_1_rev_user,
            sum(anon_1.byte_change) AS net_sum,
            sum(abs(anon_1.byte_change)) AS absolute_sum,
            sum(CASE
                    WHEN (anon_1.byte_change > 0)
                    THEN anon_1.byte_change
                    ELSE 0 END
               ) AS positive_only_sum,
            sum(CASE
                    WHEN (anon_1.byte_change < 0)
                    THEN anon_1.byte_change
                    ELSE 0 END
               ) AS negative_only_sum,
            user_registration,
            user_name
       FROM (SELECT revision.rev_user AS rev_user,
                    (   cast(revision.rev_len as signed)
                        - cast(coalesce(anon_2.rev_len, 0) as signed)
                    ) AS byte_change
               FROM revision
                        INNER JOIN
                    page        ON page.page_id = revision.rev_page
                        LEFT OUTER JOIN
                    (SELECT revision.rev_id AS rev_id,
                            revision.rev_len AS rev_len
                       FROM revision
                    ) AS anon_2 ON revision.rev_parent_id = anon_2.rev_id
              WHERE revision.rev_timestamp > '20160630235959' and revision.rev_timestamp < '20170801000000' and rev_user_text in ("GAJANAN","JAGADISH","SALUNKHE
SANTOSH","SHASHIKANT","SUTAR
PRAKASH","RAMCHANDRA","PAWAR
RAMDAS","NAGOJI","BOLAKE
HANUMANT","VITTHAL","ROHILE
SURAJ","VISHNU","PURI
अविनाश","पारगावकर","(AV)
SATISH","ASHOK","DEVEKAR
SHAIKH","MATIN
PATIL","SURYAJA","SUNIL
PATIL","SHRAVAN","DHONDIRAM
SACHIN","BHOSALE
BODHALE","GAJANAN
KAMBLE","MOHAN
MANISHA","KURANE
MARALE","S","H
KAVITA","VADRALE
MONALI","KHACHANE
YOGESH","SURESH","KHOT
CHETAN","GALAGE
GAIKWAD","SURYAKANT
URMILA","DASHWANT
प्रा.","(डॉ.)","प्रकाश","राऊत","
पोवार","किरण","दिलीप","
नंदकिशोर","गायकवाड
आसावरी","जाधव","
निलिमा","जगन्नाथ","देशमुख","
प्रणोती","हूक्केरी
ज्योती","दिपक","पाटील
संदिप","बाळासाहेब","मांगलेकर","
अनुप","गरगटे","
सोनल","चोंदे","
प्रियांका","पाटील","
प्रणित","निकम","
प्रिया","वसगडेकर","
विकास","सुरेश","हरेर","
विजय","जाधव","
प्रदीप","पाटील","
महेश","चौगले","
अविनाश","माने","
नितीन","निवृत्ती","मिसाळ","
पूनम","दादासो","पोवार","
Omkarpatil70","
Gajanansutar07","
गणेश","कदम","
अश्विनी","मोहिते","
Vinayaksalunkhe21","
स्वर्गेश","पवार
क्रांती","भोवते
सुहास","आजगावकर
तेजश्री","डिंबळे
श्रीनिवासन
मनोहरपंत","
Pravinpimparkar","
डॉ.सयाजीराव","गायकवाड","
सारंग","
भाग्यश्री","मोहिते","
प्रशांत","पानसरे","
स्वाती","नाईक","
मिरशिकारीरफ़िक़","
विष्णू","वासमकर","
माधुरी","राजाराम","मडके","
शालिनी","पुजारी
निशा","श्रीपाल","भिलवडे","
यु.उ.मकानदार
बी.एस.पाटील
सुनिता","जाधव
शिव","सोनाळकर","
शितल","पाटील
सुनीला","
गोमटेश्वर","पाटील","
मृणाली","सरिता","सतिश
कोमल","ओक
जाधव","वैभवराज","
बाहुबली","पाटील","
मयूर","सदाशिव","पाटील","
नागेश","दत्तात्रय","चिल्लाळ
प्रियांका","शेटे
राजी","
सुनिल","भिमराव","गायकवाड","
तुषार","वसंत","निरटे","
नारायण","यशवंत","रानगे","
शिवप्रसाद","सुनिल","शेवाळे","
आनंद्","वारके","
मुक्तविशाल","
ओंकार","मासरणकर","
अतुल","सुखदेव","जाधव","
सागर","कृष्णात","पाटील","
स्तवन","सोरटे","
श्रेयतोश","
धनश्री","लकडे","
श्रद्धा","कागीनकर","
विकास","कांबळे","
नंदकुमार","माेरे","
जयश्री","बनसोडे
मंजुषा","राजमाने
राविराज","पाटील
विशाल","बनसोडे
पाटलांचा","शुभम‎
आर्तु
अपर्णा","गायकवाड
दीपा","मेटी
नूतन","सावंत
प्रविण","कांबळे
प्रथमेश","खोत
गणेश","पवार
Kaju","hegade
रविराज","पाटील
शकील","जिलानी","शेख
किरण","माळी
मनीषा","पांडुरंग","वसगडेकर
विकास","शामराव","पाटील
सुप्रिया","कदम","
पोखरकर","अनु","
Pooja","Jadhav","
प्रियांका","भोसुरे","","
तळोले","मोना","","
कांबळे","प्रमिला","
आश्विनी","बाळासाहेब","दौंडकर","","
जयश्री","दौंडकर","
साळुंके","सुवर्णा","
संदीप","जौंजाळ","","
दामिनी","दौंडकर","
प्रसाद","शिळीमकर","
रुपाली","तांबे","","
चैताली","कंद्रुप","
योगेश","कुलकर्णी","","
कोमल","राऊत","
राणी","थिटे","
वाघोले","रुपाली","
युसरा","पटेल","
प्रतिक्षा","सुक्रे","
विवेक","गिरिधारी","
सागर","शिंदे","
राम","डिंबळे","","
निलेश","धायरकर","","
धर्मराज","वीर","
मेघा","नगरे","
सुधीर","ज्ञानेश्वर","सुकाळे
विशाल","देशपांडे
शैलेंद्र","पाटील
नीता","ग.","पौरस
भास्कर","व्यंकटराव","गिरधारी
माधुरी","कुदळे
स्नेहा","गोरे
राहुल","म्हैसकर
पुरूषोत्तम","सुनील","बेहेरे
Kishor","Udapi
Punam","Kirawe
Varsha","Sawant
Priyanka","Bhosure
Nagesh","Kulkarni
Ujjwala","Pawar
Aarya","Joshi
Manisha","Shete
Rajendra","Prabhune
Satish","Bangar
Vikas","Chavan
Amit","Shinde
Pooja","Jadhav
सुप्रिया","कदम
माधुरी","करवडे
चंदा","पागे
प्रीती","जोशी
मनिषा","देशपांडे
सुनीता","गायकवाड
मनीषा","शेटे
उज्ज्वला","पवार
Vasu","kohli","BVPNLC","
Rishab","Sharma","BVPNLC","
‎Nikhil","Pandey","BVPNLC","
‎Shaambhavi","Sinha","BVPNLC","
Vishesh","Kumar","Singh","BVPNLC","
Kritika","goyal","BVPNLC","
‎Rajat","Shukla","BVPNLC1","
Sather","Singh","BVPNLC","
Hrithik","Chaudhary","BVPNLC","
Siddharth","Sachan","BVPNLC","
Twinkle","Jha","BVPNLC","
Shweta","Kumari","BVPNLC","
Dipankar","Singh","BVPNLC","
Kamran","Alam","BVPNLC1","
Utkarsh","Mishra","BVPNLC1
Nikunj","Mittal","BVPNLC1
Pukhraj","Chaturvedi","BVPNLC1
Priya","BVPNLC1
Shivangini","Shukla
‎Mayank","Kumar","BVPNLC1
Shreya","BVPNLC
Ravi","BVPNLC
Avinov","Suman","bvpnlc1
Chakshu","Thakral","BVPNLC2
Ashish","Panday","BVPNLC
Medha","Shahi","BVPNLC2
Subhagyabvpnlc1
Bhawna","Sharma","BVPNLC
Jyoti","Mishra","BVPNLC
Dhananjay","Joshi","BVPNLC
Gulfeshan","kamaal
Nisha","Bhagawat","BVPNLC
Samujjal","Choudhury","BVPNLC
Nisha","Bhagawat","BVPNLC
Saurabh","kumar","Jaiman
Sharika","Sristi","BVPNLC1
Diksha","Bhasin","BVPNLC
Pushkar","Raj","BVPNLC
Rohit","Kumar","BVPNLC
Deeksha","Bajpai","BVPNLC
Neel","Misra","BVPNLC
Sunita","bal","bvpnlc
Natasha","Jain","BVPNLC
Kukreja","kajal","BVPNLC
Avil","Kaintura","BVPNLC
Anima","Singh","BVPNLC
Surbhi","Notyal","BVPNLC
‎Vinayak","Tiwari","BVPNLC
Razia","Wadhwa","BVPNLC
Pratik","Jain","BVPNLC
Dipanjali","Dutta","BVPNLC
Anant","Nigam","BVPNLC
Samriddh","Gupta","BVPNLC
Shailabh","Tiwari
Mohit","Yadav","BVPNLC
Shivangi","Srivastava","BVPNLC
Aayushi","Anand","BVPNLC
Swapnil","Bharati","BVPNLC
Anamika","Sharma","BVPNLC
Anuradha","Mehrotra","BVPNLC
Anubhav","Pandey","BVPNLC
Siddharth","singh","BVPNLC
आदिती","गर्गे","
अर्जुन","कोमल","आमते","
डॉ.","विश्वरंजन","सोमनाथ","
संग्राम","जाधव","
सोनल","सुनिल","मगर","
सिमरन","शहाबुद्दिन","टाकवडे","
आकांक्षा","प्रदीप","पाटील","
अभिजीत","शांताराम","पाटील","
सरवदे","पुनम","गौतम","
ज्योती","विजय","तोडकर","
तेजस्विनी","प्रकाश","मेथे","
शितल","महादेव","चव्हाण","पाटील","
तरन्नुम","अस्लम","शेख","
प्रतिक्षा","शिवाजी","पन्हाकर","
शिवानंद","शंकर","गड्डी","
डॉ.","व्ही.","बी.","पाटील","
मोळे","स्वरूपा","बाळासाहेब","
स्नेहल","पोवार","
स्केटी","महेश","भालेराव","
राजीव","बाबुराव","हुंशाल
मिनल","सुरेश","ओसवाल","
संगम","अनिल","नाईक","
प्रियदर्शिनी","उदय","माळी","
ऐश्वर्या","सुरेश","भांडे","
स्नेहा","दत्ताजीराव","देसाई","
उमेश","भगवान","वाठारकर","
श्वेता","देवाप्पा","नवनाळे","
प्राजक्ता","प्रकाश","मगदुम","
रोहित","खाडे","
निखिता","जयंत","जोशी","
निकम","प्रियंका","दिलीप","
शिवम","राकेश","शर्मा","
स्नेहलदेशमुख८९","
जयेश","मधुकर","धबाले","
माधुरी","गावित","
प्रतिभा","आनंद","फाटक","
आरती","भोसिकर","
रेणुका","देशपांडे","
सोनाली","
Suhasajgaonkar","
अदिती","शार्दुल","
Avinash","tambekar","
Pradnya","baliram","more","
सारिका","कुलकर्णी","
शिल्पा","78","
गजानन","सायखेडकर","
Dr.","Nandkishor","Sonwane","
भाग्यश्री","आत्माराम","पाटील","
Ysingare","
Nitinvakle","
डॉ.","विनय","धर्माधिकारी","
सई","पाटील","
GAURAV","R","KARLE","
Dr.","ambadas","kulkarni","
प्रज्ञा","मोरे","
विजय","एदलाबादकर
पांडुरंग","ढेरे","
राजेश","मुरलीधर","सोनवने","
अनिल","वारे","
शंकर","वाकचौरे
भारती","बढे
दादाजी","देवरे","
मारुती","शिंदे","
गुरुदत्त","पवार","
विनायक","वडघुले","
कैलास","जाधव","
उत्तम","उगले","
ज्योती","पाटील","
हनमंत","तिवले","
वसंत","बोराडे","
विलास","आदलिंगे","
गणेश","पिंगळे","","
किसन","वरखडे","","
सचिनपुणेकर०१","
महेंद्र","भोर","","
पोखरकर","अनु","","
विजय","साळवे","","
नेहा","बेंद्रे","पाटील","
समीर","बुर्ले
विशाल","नारायण","
संदीप","गजानन","श्रोत्री","
करंबेळकर","
अनिल","दातीर","
Rajendra","prabhune","
धीरज","लढ्ढा
Shailesh","1410","
Sagarzoo","
U.r.mote","
कैवल्य","देशपांडे","
कल्याणी","कांबळे","
धनंजय","चौगुले","
अमर","अशोक","काटे","
सुजीत","शरद","शेसगे","
रविद्र","चाळके","
वर्षा","देशपाडे","
Piyush","Desai","
राजीव","मुळ्ये","
Chandrakant","waghmale","
Vicky5275")) AS anon_1
       JOIN user ON user_id=rev_user
GROUP BY user_name
ORDER BY absolute_sum DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
