<div dir="ltr"><div>Hello everyone,</div><div><br></div><div>I have an example job from my client and figuring out it with postgresql. I imported the csv data which is approx. 3 million rows. I'm trying to get for example how many airport id has EGLL code but not with where command. Tried to sum but didnt work. We were doing same thing before at my previous job. Every help appreciated. <br></div><div><br>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><table style="color:ws-gmail-api-sig;max-width:600px;direction:ltr">
                        <tbody><tr><td> 
                         <table style="max-width:470px;padding-bottom:10px;margin-bottom:8px" cellspacing="0" cellpadding="0" border="0"> <tbody><tr> <td>  <table style="width:470px" width="470" cellspacing="0" cellpadding="0" border="0"> <tbody><tr valign="top"> <td style="text-align:initial;font:12px Arial;color:#646464;padding:0 10px"> <div style="margin-bottom:5px;margin-top:0!important"><b>Taylan Karakurt</b><br> <span>Data/GIS Specialist - Geomatic Engineer</span> </div> <table style="width:470px;margin-top:5px" width="470" cellspacing="0" cellpadding="0" border="0"> <tbody><tr> <td style="color:#8d8d8d;font-size:12px"> <p style="margin:0"> <span style="display:inline-block"><a href="tel:+90+536+217+86+47" style="color:#8d8d8d;text-decoration:none;font-family:sans-serif" target="_blank">+44 7566 892362</a></span>  <span style="color:#45668e;display:inline-block">|</span> <span style="display:inline-block"><a href="mailto:karakurttaylan46@gmail.com" style="color:#8d8d8d;text-decoration:none;font-family:sans-serif" target="_blank">karakurttaylan46@gmail.com</a></span> </p> </td> </tr> <tr> <td style="color:#8d8d8d;font-size:12px">  <p style="margin:0"> <span style="display:inline-block"><span style="color:#8d8d8d">Skype: <a href="#SignatureSanitizer_SafeHtmlFilter_" style="text-decoration:none;color:#8d8d8d;font-family:sans-serif">live:karakurttaylan46</a></span></span>  </p> </td> </tr> </tbody></table> <div style="margin-top:10px"><table cellspacing="0" cellpadding="0" border="0"><tbody><tr style="padding-top:10px"><td style="padding-right:5px;text-align:center;padding-top:0" align="left"> <a href="http://linkedin.com/in/taylankarakurt" target="_blank"><img src="http://cdn.gifo.wisestamp.com/social/linkedin/0077b5/16/0.png"></a></td></tr></tbody></table></div> </td> </tr> </tbody></table> </td> </tr> </tbody></table> <table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td></td></tr></tbody></table></td></tr></tbody></table>
                        <div href="http://WS_promo" style="width:auto;padding-top:2px;font-size:10px;border-top-width:1px;border-top-style:solid;border-top-color:rgb(238,238,238);margin-top:10px;display:table;direction:ltr;line-height:normal;border-spacing:initial">
        <div style="padding-top:2px">
                <a href="https://www.wisestamp.com/signature-in-email?utm_source=promotion&utm_medium=signature&utm_campaign=create_your_own" style="color:#000;text-decoration:none" target="_blank">Create your own <span style="color:#a50310">email signature</span></a>
        </div>
</div>
                        
                
        </div></div></div>