Fullstack Developer

You are given a binary matrix with ‘M’ rows and ‘N’ columns initially consisting of all 0s. 'Q' queries follow. The queries can be of 4 types:

Query 1: 1 R index
Query 2: 1 C index 
Query 3: 2 R index
Query 4: 2 C index

In each query, the first input is the type of the query, the second input is whether we have to consider the row ('R') or the column ('C') and the third input is the index of the row/column. 

For each type 1 query, we need to flip the elements of the row/column having the given index. 

For each type 2 query, we have to output the number of zeros present in the row/column having the given index. 

Note:

Note that the matrix is a binary matrix, meaning that it only contains either 0 or 1.

Example :

Given M = 3, N = 3, 
Queries : 1R1, 1R2, 2C1

So, in the above example the change in the matrix would look like this:

Next query 2C1 will return the count of the number of zeroes in the 1st column: 1

You are given the details of retail outlet. Your task is to analyze the data from the provided relations and write an SQL query to display the names and number of distinct locations where the retail outlets are present.
Consider only those outlets that are not located in New York and the ones where the number of salesman is only.

1. Display the data in alphabetical order of their name.

Relation 1: SalesMan(SMID(Integer), Sname(String), Manager(Integer), ROID(Integer))
Relation 2: RetailOutlet(ROID(Integer), RName(String), Year_Of_Estb(Integer), Location(String))

RetailOutlet:
ROID RName Year_Of_Estb Location
1. A&S Comp. 1985 New York
2. InforTech Ltd. 1974 Chicago
3. Allen Group 1999 Chicago
4. Brisk Ltd. 1975 Los Angles

SalesMan
SMID Sname Manager ROID
101 Jack NULL 3
104 Fmily 106 2
105 Ayaz 111 3
107 Joe 110 1
110 Mckarthy NULL 4
111 John NULL 3
112 Jason 113 1
115 Alan NULL 4

Output:
RName Count
Infotech Ltd. 1

The HR asked me about the hackathon experience?
Why to join DBS?
Do you have any plan for higher education?

Initially asked about to introduce about myself.
Which language are you comfortable with?
What are the Java OOPS concepts?
What is meant by Encapsulation with real-time example?
What is meant by inheritance? Does java support multiple inheritance? 
How can it achieve multiple inheritance?
What is meant by Diamond problem?
What is meant by stack and Queue in detail?
Which data structure is used for the lift?
How do you implement multithreading(two ways)?
Which one is better either the Thread class or the Runnable interface and why?