\[ \begin{array}{|c|c|c|c|} \hline \textbf{S\_id} & \textbf{S\_name} & \textbf{Address} & \textbf{S\_type} \\ \hline S001 & Sandhya & Rohini & Day Boarder \\ S002 & Vedanshi & Rohtak & Day Scholar \\ S003 & Vibhu & Raj Nagar & NULL \\ S004 & Atharva & Rampur & Day Boarder \\ \hline \end{array} \]
\[ \begin{array}{|c|c|c|} \hline \textbf{S\_id} & \textbf{Bus\_no} & \textbf{Stop\_name} \\ \hline S002 & TSS10 & Sarai Kale Khan \\ S004 & TSS12 & Sainik Vihar \\ S005 & TSS10 & Kamla Nagar \\ \hline \end{array} \]
Query (i): Display the student name and their stop name from the tables Admin
and Transport
.
SELECT A.S_name, T.Stop_name FROM Admin A, Transport T WHERE A.S_id = T.S_id;
Explanation:
The INNER JOIN
combines the tables Admin
and Transport
based on the common column S_id
.
The query retrieves the S_name
from Admin
and Stop_name
from Transport
.
The SELECT statement when combined with \(\_\_\_\_\_\_\) clause, returns records without repetition.
In SQL, the aggregate function which will display the cardinality of the table is \(\_\_\_\_\_\).
myStr = "MISSISSIPPI" print(myStr[:4] + "#" + myStr[-5:])
Rupal, Shanu and Trisha were partners in a firm sharing profits and losses in the ratio of 4:3:1. Their Balance Sheet as at 31st March, 2024 was as follows:
(i) Trisha's share of profit was entirely taken by Shanu.
(ii) Fixed assets were found to be undervalued by Rs 2,40,000.
(iii) Stock was revalued at Rs 2,00,000.
(iv) Goodwill of the firm was valued at Rs 8,00,000 on Trisha's retirement.
(v) The total capital of the new firm was fixed at Rs 16,00,000 which was adjusted according to the new profit sharing ratio of the partners. For this necessary cash was paid off or brought in by the partners as the case may be.
Prepare Revaluation Account and Partners' Capital Accounts.