<div>
try this
<pre><code id="code-20-39913601-1">SELECT CATEGORY,TYPE_P+TYPE_T AS Quantity,TYPE_P,TYPE_T 
  FROM (SELECT *
          FROM test
         PIVOT (COUNT(TYPE1) FOR TYPE1 IN ('P' as TYPE_P,'T' as TYPE_T)) P1) T1</code></pre>
<a href="http://sqlfiddle.com/#!4/bcf20/11" rel="ugc">http://sqlfiddle.com/#!4/bcf20/11</a>
</div>


try this

SELECT CATEGORY,TYPE_P+TYPE_T AS Quantity,TYPE_P,TYPE_T 
  FROM (SELECT *
          FROM test
         PIVOT (COUNT(TYPE1) FOR TYPE1 IN ('P' as TYPE_P,'T' as TYPE_T)) P1) T1

http://sqlfiddle.com/#!4/bcf20/11 [http://sqlfiddle.com/#!4/bcf20/11]

<div>
exactly what I am looking for!!!!
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have the following table<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/03_w10/838759/Screen-Shot-2014-03-07-at-4.44.4.png" target="_blank" title="TABLES DESCRIPTIONS (28 KB)"><img alt="TABLES DESCRIPTIONS" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/03_w10/800_838759/Screen-Shot-2014-03-07-at-4.44.4.png" /></a><br />
The table is in a database table. I need a query that produces the second table, that is a resume of the first table, any idea?
</div>
</div>


Screen-Shot-2014-03-07-at-4.44.4.png

Hi,

I have the following table



The table is in a database table. I need a query that produces the second table, that is a resume of the first table, any idea?

calculated fields like where inside where

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.