Answer / kavitha nedigunta

select city,
count(decode(lower(gender),'male','female',null)) male,
count(decode(lower(gender),'female','male',null)) female
from gen
group by city;

Answer / sp

SELECT
city, COUNT(
CASE gender
WHEN 'male' THEN 'male'
END ) AS 'male' ,COUNT(
CASE gender
WHEN 'female' THEN 'female'
END ) AS 'female'
FROM info AS u group by city;

What are the different ways to optimize a sql query?

1 Answers  

---

What are different types of queries in sql?

1 Answers  

---

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1 Answers   ABC,

---

how to return query output in html format? : Sql dba

1 Answers  

---

Which is better cte or subquery?

1 Answers  

---

what are date and time functions in mysql? : Sql dba

1 Answers  

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1 Answers  

---

What are the disadvantages of not performing database normalization?

1 Answers  

---

Types of cursors and explanation each of them ?

4 Answers   DELL,

---

What is oracle sql developer?

1 Answers  

---

Can we commit inside a trigger?

1 Answers  

---

How many developers work on postgresql?

1 Answers  

---