L. WAQTD NUMBER OF EMPLOYEES HIRED ON THE SAME DAY INTO THE SAME DEPARTMENT
Answers
Answer:
Select the department and hired on same column.
Explanation:-
1. If your data are in a full-fledged Excel table, just click on any cell in the column and press Ctrl+Space.
2. If you have a simple range (when you click on any cell with the data, you don't see "Table Tools" tab in the top-right corner of the Excel ribbon):
3. Put the cursor to the first cell in the column (or the second one if your Table has headers), then press Shift+Ctrl+End to go to the end of your table, hold Shift and press the Left key repeatedly until only the needed column gets selected. This is the fastest way to select all the cells in the column, especially if the column contains several blank cells between the data.
4. If your data are in a full-fledged Excel table, just click on any cell in the row and press Shift+Space.
5. If you have a simple range, click on the last cell in the row, then press Ctrl + Home.
6. Convert your range to an Excel table. Select any cell within your data range and press Ctrl+T to bring the "Create Table" dialog (the shortcut is Ctrl+L in Excel 2003). If your data have column titles, make sure the checkbox "My table has headers" is selected. Usually Excel recognizes your table headers automatically, if not, check this checkbox manually.
7.Insert a new column into your table. It is a lot easier to add a new column to a table than to a simple data range. Just click on any cell in the column next to where you want to add a new one and choose Insert > Table Column to the Right ( or "Table Column to the Left").
8.Select the cells that you want to fill with the same data in your Excel worksheet. Please see the tips above for quick data selection. Say, we have a table with a list of our customers (this is a fake list, of course There is a column listing the websites from which our customers come. We want to fill the blank cells with "_unknown_" to make filtering easier in the future.
For more refers to-
https://brainly.in/question/1300960?referrer=searchResults
https://brainly.in/question/41302020?referrer=searchResults
#SPJ3
Answer:
select count(*),hiredate,deptno
from emp
group by hiredate,deptno
having count(*)=2;