Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
dayna
Starting Member
14 Posts |
Posted - 2012-12-03 : 20:34:08
|
I am trying to get a count of transactions from a table,all i want is view only the month and the year that the transaction correspond in.. but this code show all the months and year of every transaction.here is the code: SELECT TOP 100 PERCENT MONTH(dttTransactionDate) AS TRANSMONTH, YEAR(dttTransactionDate) AS TRANSYEAR, COUNT(*) AS NoOfTransactionMonthly, COUNT(DISTINCT dttTransactionSymbol) AS TRANSACTIONSYMBOL, dttBranchCode, dttProductCode, dttSequence, dttCheckDigit, datDepositorName AS DEPOSITORNAME, datDepositorAddress AS DEPOSITORADDRESS, dttErrorCorrect AS ErrorCorrectFROM dbo.DEPOSITTRANSACTIONGROUP BY MONTH(dttTransactionDate), YEAR(dttTransactionDate), dttBranchCode, dttProductCode, dttSequence, dttCheckDigit, datDepositorName, datDepositorAddress, dttErrorCorrectHAVING (YEAR(dttTransactionDate) <> 2011)ORDER BY MONTH(dttTransactionDate), YEAR(dttTransactionDate), dttSequencehelp me pls... im using sql server 2000dcometa |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-12-03 : 22:55:31
|
quote: the month and the year that the transaction correspond in
what do you mean by that ? KH[spoiler]Time is always against us[/spoiler] |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2012-12-03 : 23:30:24
|
[code]SELECT TOP 100 PERCENT MONTH(dttTransactionDate) AS TRANSMONTH, YEAR(dttTransactionDate) AS TRANSYEAR, COUNT(*) AS NoOfTransactionMonthly, COUNT(DISTINCT dttTransactionSymbol) AS TRANSACTIONSYMBOL , dttBranchCode, dttProductCode, dttSequence, dttCheckDigit, datDepositorName AS DEPOSITORNAME, datDepositorAddress AS DEPOSITORADDRESS, dttErrorCorrect AS ErrorCorrectFROM dbo.DEPOSITTRANSACTIONGROUP BY MONTH(dttTransactionDate), YEAR(dttTransactionDate) , dttBranchCode, dttProductCode, dttSequence, dttCheckDigit, datDepositorName, datDepositorAddress, dttErrorCorrectHAVING (YEAR(dttTransactionDate) <> 2011)ORDER BY MONTH(dttTransactionDate), YEAR(dttTransactionDate)[/code]--Chandu |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-04 : 01:09:33
|
why do you need top 100 percent here? is this used inside some subquery?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
dayna
Starting Member
14 Posts |
Posted - 2012-12-04 : 20:35:55
|
i used the top 100 percent in order to view all accounts together with transactions for each depositor. the script i posted while ago is running already, but my problem is that it shows all the months and the year of every depositor transactions. i want only to view the the latest month and year of every transaction of each depositors.again the script look like this:SELECT TOP 100 PERCENT MONTH(dttTransactionDate) AS TRANSMONTH, YEAR(dttTransactionDate) AS TRANSYEAR, COUNT(*) AS NoOfTransactionMonthly,COUNT(DISTINCT dttTransactionSymbol) AS TRANSACTIONSYMBOL, dttBranchCode, dttProductCode, dttSequenceFROM dbo.DEPOSITTRANSACTIONGROUP BY MONTH(dttTransactionDate), YEAR(dttTransactionDate), dttBranchCode, dttProductCode, dttSequenceHAVING (YEAR(dttTransactionDate) <> 2011)ORDER BY MONTH(dttTransactionDate), YEAR(dttTransactionDate), dttSequencethe result:TransMonth TransYear NoOfTransaction TransSymbol dttBranchCode dttProductcode dttsequence 11 2011 6 cd 10005 001 00003212 2011 3 cd 10005 001 0000321 2012 4 cd 10005 001 0000322 2012 6 cw 10005 001 0000323 2012 5 cd 10005 001 0000324 2012 6 cd 10005 001 0000325 2012 8 cw 10005 001 0000326 2012 9 cw 10005 001 0000327 2012 3 cd 10005 001 0000328 2012 1 cd 10005 001 0000329 2012 9 cd 10005 001 00003210 2012 2 cw 10005 001 00003211 2012 4 cd 10005 001 00003212 2012 2 cd 10005 001 000032for this result i want only to view the month and the year where in the depositor last transaction..example result above i want only:TransMonth TransYear NoOfTransaction TransSymbol dttBranchCode dttProductcode dttsequence 12 2012 2 cd 10005 001 000032pls help me asap..im using sql server 2000.sorry for my wrong english.tnx for the help.. dcometa |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2012-12-05 : 00:57:26
|
SELECT TOP 1..........FROM.......ORDER BY YEAR(dttTransactionDate) DESC, MONTH(dttTransactionDate) DESC, dttSequence--Chandu |
|
|
dayna
Starting Member
14 Posts |
Posted - 2012-12-05 : 03:46:00
|
I am trying to get a count of transactions from a table, but I can't seem to get sql to get me to show all of the months instead of only the months and the year that the transactions occured in.Here is the query:SELECT MONTH(dttTransactionDate) AS TRANSMONTH, YEAR(dttTransactionDate) AS TRANSYEAR, COUNT(*) AS NoOfTransactionMonthly,COUNT(DISTINCT dttTransactionSymbol) AS TRANSACTIONSYMBOL, dttBranchCode, dttProductCode, dttSequenceFROM dbo.DEPOSITTRANSACTIONGROUP BY MONTH(dttTransactionDate), YEAR(dttTransactionDate), dttBranchCode, dttProductCode, dttSequenceHAVING (YEAR(dttTransactionDate) <> 2011)ORDER BY MONTH(dttTransactionDate), YEAR(dttTransactionDate), dttSequenceThe query returns the following result set:| Transmonth | Transyear | Transnumber || Transsymbol | dttbranchcode | dttproductcode |dttsequence|-----------|------------|----------| |----------- |------------ |---------- || 12 | 2011 | 5 | | 2 | 1 | 001 | 00001| 1 | 2012 | 1 | | 1 | 1 | 001 | 00002| 2 | 2012 | 2 | | 2 | 1 | 001 | 00001| 2 | 2012 | 3 | | 2 | 1 | 001 | 00002| 3 | 2012 | 2 | | 2 | 1 | 001 | 00002and so forth.... but the result im trying to look for is not that one..here is i want to show : from the result above, in dttsequence column (00001) the latest transaction there is feb. 2012 and the old transaction is dec. 2011.. sequence (00002) the latest transaction there is march 2012 and the old transaction is jan. 2012..here is the result that i want to show on my table:| Transmonth | Transyear | Transnumber || Transsymbol | dttbranchcode | dttproductcode |dttsequence| 2 | 2012 | 2 | 2 | 1 | 001 | 00001| 3 | 2012 | 2 | 2 | 1 | 001 | 00002tnx for helping again...dcometa |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2012-12-05 : 05:16:57
|
hi dayna,I am not getting exact solution for you. Can you post only actual table data and the expected output?NoOfTransactionMonthly --> Total number of transactions per month regardless of year ( or with respect to year also ? )TRANSACTIONSYMBOL --> u r counting different trans symbols hereand one more column is RecentTransactionDate for each dttsequence.. right??If you post actual data and expected result, we can easily provide the solution--Chandu |
|
|
dayna
Starting Member
14 Posts |
Posted - 2012-12-05 : 20:26:59
|
here is the complete table..@TABLE: FROM DMMDEPOSITTRANSACTION| DTTBRANCHCODE | DTTPRODUCTCODE| DTTSEQUENCE || DTTCHECKDIGIT | DTTTRANSACTIONDATE || 10005 | 001 | 00001 |01 |12/23/2011 || 10005 | 001 | 00001 |01 |12/24/2011 || 10005 | 001 | 00001 |01 |12/26/2011 || 10005 | 001 | 00001 |01 |12/27/2011 || 10005 | 001 | 00001 |01 |12/28/2011 || 10005 | 001 | 00002 |02 |01/3/2012 || 10005 | 001 | 00001 |01 |02/6/2012 || 10005 | 001 | 00001 |01 |02/7/2012 || 10005 | 001 | 00002 |02 |02/8/2012 || 10005 | 001 | 00002 |02 |02/9/2012 || 10005 | 001 | 00002 |02 |02/10/2012 || 10005 | 001 | 00002 |02 |03/12/2012 || 10005 | 001 | 00002 |02 |03/13/2012 || DTTTRANSACTIONSYMBOL|| CD | | CW | | CD | | CD | | CW | | CW | | CD | | CD | | CD | | CW | | CD | | CD | | CD | HERE IS MY VIEW TABLE (IM CALLING THE DTTTRANSACTION TABLE):SELECT MONTH(dttTransactionDate) AS TRANSMONTH, YEAR(dttTransactionDate) AS TRANSYEAR, COUNT(*) AS NoOfTransactionMonthly, COUNT(DISTINCT dttTransactionSymbol) AS TRANSACTIONSYMBOL, dttBranchCode, dttProductCode, dttSequence, dttCheckDigitFROM dbo.dmmDepositTransactionGROUP BY MONTH(dttTransactionDate), YEAR(dttTransactionDate), dttBranchCode, dttProductCode, dttSequence, dttCheckDigitHAVING (YEAR(dttTransactionDate) <> 2011)ORDER BY MONTH(dttTransactionDate), YEAR(dttTransactionDate), dttSequenceThe query returns the following result set:| Transmonth | Transyear | Transnumber || Transsymbol | dttbranchcode | dttproductcode |dttsequence|dttcheckdigit|-----------|------------|----------| |----------- |------------ |---------- || 12 | 2011 | 5 | | 2 | 1 | 001 | 00001|01| 1 | 2012 | 1 | | 1 | 1 | 001 | 00002|02| 2 | 2012 | 2 | | 2 | 1 | 001 | 00001|01| 2 | 2012 | 3 | | 2 | 1 | 001 | 00002|02| 3 | 2012 | 2 | | 2 | 1 | 001 | 00002|02and so forth.... but the result im trying to look for is not that one..here is i want to show :from the result above, in dttsequence column (00001) the latest transaction there is feb. 2012 and the old transaction is dec. 2011.. sequence (00002) the latest transaction there is march 2012 and the old transaction is jan. 2012..here is the result that i want to show on my views table:| Transmonth | Transyear | Transnumber || Transsymbol | dttbranchcode | dttproductcode |dttsequence|dttcheckdigit| 2 | 2012 | 2 | 2 | 1 | 001 | 00001|01| 3 | 2012 | 2 | 2 | 1 | 001 | 00002|02NoOfTransactionMonthly ---> total number of transaction per month with the corresponding recent yeartransactionsymbol --> yes im counting differenct trans symbols(cd and cw)for each dttsequence.note: counting of nooftransactionmonthly and transactionsymbol is every dttsequence.tnx...dcometa |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-06 : 00:58:11
|
[code]SELECT YEAR(DTTTRANSACTIONDATE) AS TransYear,MONTH(DTTTRANSACTIONDATE) AS TransMonth,COUNT(DTTTRANSACTIONDATE) AS Transnumber,COUNT(DISTINCT DTTTRANSACTIONSYMBOL) AS Transymbol,COUNT(DTTBRANCHCODE) AS dttbranchcode,DTTPRODUCTCODEFROM(SELECT *,MAX(DTTTRANSACTIONDATE) OVER (PARTITION BY DTTSEQUENCE ) AS MaxDateFROM dbo.dmmDepositTransaction)tWHERE DTTTRANSACTIONDATE > = DATEADD(mm,DATEDIFF(mm,0,MaxDate),0)AND DTTTRANSACTIONDATE < DATEADD(mm,DATEDIFF(mm,0,MaxDate)+1,0)GROUP BY YEAR(DTTTRANSACTIONDATE),MONTH(DTTTRANSACTIONDATE),DTTPRODUCTCODE[/code]------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2012-12-06 : 01:14:02
|
Alternate is:DECLARE @DMMDEPOSITTRANSACTION TABLE(DTTBRANCHCODE int, DTTPRODUCTCODE varchar(10), DTTSEQUENCE varchar(10), DTTCHECKDIGIT varchar(10), DTTTRANSACTIONDATE date, DTTTRANSACTIONSYMBOL varchar(10))INSERT INTO @DMMDEPOSITTRANSACTION SELECT '10005', '001', '00001', '01', '12/23/2011', 'CD' union allSELECT '10005', '001', '00001', '01', '12/24/2011', 'CW' union allSELECT '10005', '001', '00001', '01', '12/26/2011', 'CD' union allSELECT '10005', '001', '00001', '01', '12/27/2011', 'CD' union allSELECT '10005', '001', '00001', '01', '12/28/2011', 'CW' union allSELECT '10005', '001', '00002', '02', '01/3/2012', 'CW' union allSELECT '10005', '001', '00001', '01', '02/6/2012', 'CD' union allSELECT '10005', '001', '00001', '01', '02/7/2012', 'CD' union allSELECT '10005', '001', '00002', '02', '02/8/2012', 'CD' union allSELECT '10005', '001', '00002', '02', '02/9/2012', 'CW' union allSELECT '10005', '001', '00002', '02', '02/10/2012', 'CD' union allSELECT '10005', '001', '00002', '02', '03/12/2012', 'CD' union allSELECT '10005', '001', '00002', '02', '03/13/2012', 'CD' ;WITH CTE AS( SELECT DTTSEQUENCE, MAX(DTTTRANSACTIONDATE) RecentTransDate, COUNT( distinct DTTTRANSACTIONSYMBOL) noOfTransSymls FROM @DMMDEPOSITTRANSACTION GROUP BY DTTSEQUENCE)SELECT distinct MONTH(RecentTransDate) TranMonth, YEAR(RecentTransDate) TransYear,COUNT(d.DTTTRANSACTIONDATE ) OVER(Partition by c.DTTSEQUENCE) noOfTrans,noOfTransSymls, d.DTTBRANCHCODE, d.DTTPRODUCTCODE, c.DTTSEQUENCE, d.DTTCHECKDIGIT FROM @DMMDEPOSITTRANSACTION d JOIN CTE c ON CONVERT( VARCHAR(7), d.DTTTRANSACTIONDATE, 102) = CONVERT( VARCHAR(7), c.RecentTransDate, 102) AND c.DTTSEQUENCE = d.DTTSEQUENCE --Chandu |
|
|
dayna
Starting Member
14 Posts |
Posted - 2012-12-06 : 03:31:35
|
is that query applicable with sql server 2000? because I've tried to run the query it will come up an error.thank you for the help..---im using ms sql server 2000---dcometa |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2012-12-06 : 04:22:02
|
[CODE]-- In mssql 2000SELECT MONTH(RecentTransDate) TranMonth, YEAR(RecentTransDate) TransYear, noOfTransSymls, noOfTrans, DTTPRODUCTCODE, DTTBRANCHCODE, DTTSEQUENCE, DTTCHECKDIGITFROM ( SELECT distinct noOfTransSymls, COUNT(*) noOfTrans, d.DTTBRANCHCODE, d.DTTPRODUCTCODE, c.DTTSEQUENCE, d.DTTCHECKDIGIT, RecentTransDate FROM @DMMDEPOSITTRANSACTION d JOIN (SELECT DTTSEQUENCE, MAX(DTTTRANSACTIONDATE) RecentTransDate,COUNT( distinct DTTTRANSACTIONSYMBOL) noOfTransSymls FROM @DMMDEPOSITTRANSACTION GROUP BY DTTSEQUENCE ) c ON CONVERT( VARCHAR(7), d.DTTTRANSACTIONDATE, 102) = CONVERT( VARCHAR(7), c.RecentTransDate, 102) AND c.DTTSEQUENCE = d.DTTSEQUENCE GROUP BY c.DTTSEQUENCE, d.DTTBRANCHCODE, d.DTTPRODUCTCODE, d.DTTCHECKDIGIT, RecentTransDate, noOfTransSymls )t[/CODE]--Chandu |
|
|
dayna
Starting Member
14 Posts |
Posted - 2012-12-09 : 20:48:42
|
thank you for the script chandu it works perpectly..---another question related to the topic above-- Is it possible that in dmmDepositTransaction Table can i automatically count the transaction by month instead of adding another table in views which is the table t (basis is the query above)? if that's the case how can i add it into my script? because base on the query above i have encounter an error if i will call it into my vb6 code, the data is not accumulate counting, the difference has lack of 2 transaction every month. maybe because im using views table even though the views table t is exactly counting the transaction but if i will call it to my vb code then run the program itself it lack of 2 transactions.here is the table dmmdeposittransaction and how will i add the transaction count by month:@TABLE: FROM DMMDEPOSITTRANSACTION| DTTBRANCHCODE | DTTPRODUCTCODE| DTTSEQUENCE || DTTCHECKDIGIT | DTTTRANSACTIONDATE || 10005 | 001 | 00001 |01 |12/23/2011 || 10005 | 001 | 00001 |01 |12/24/2011 || 10005 | 001 | 00001 |01 |12/26/2011 || 10005 | 001 | 00001 |01 |12/27/2011 || 10005 | 001 | 00001 |01 |12/28/2011 || 10005 | 001 | 00002 |02 |01/3/2012 || 10005 | 001 | 00001 |01 |02/6/2012 || 10005 | 001 | 00001 |01 |02/7/2012 || 10005 | 001 | 00002 |02 |02/8/2012 || 10005 | 001 | 00002 |02 |02/9/2012 || 10005 | 001 | 00002 |02 |02/10/2012 || 10005 | 001 | 00002 |02 |03/12/2012 || 10005 | 001 | 00002 |02 |03/13/2012 || DTTTRANSACTIONSYMBOL|| CD || CW || CD || CD || CW || CW || CD || CD || CD || CW || CD || CD || CD |pls help me..i really need it..pls.pls......dcometa |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2012-12-10 : 00:00:53
|
Just create this view..... What is the problem with t query?CREATE VIEW myView AsSELECT MONTH(RecentTransDate) TranMonth, YEAR(RecentTransDate) TransYear, noOfTransSymls, noOfTrans, DTTPRODUCTCODE, DTTBRANCHCODE, DTTSEQUENCE, DTTCHECKDIGITFROM ( SELECT distinct noOfTransSymls, COUNT(*) noOfTrans, d.DTTBRANCHCODE, d.DTTPRODUCTCODE, c.DTTSEQUENCE, d.DTTCHECKDIGIT, RecentTransDate FROM DMMDEPOSITTRANSACTION d JOIN (SELECT DTTSEQUENCE, MAX(DTTTRANSACTIONDATE) RecentTransDate,COUNT( distinct DTTTRANSACTIONSYMBOL) noOfTransSymls FROM DMMDEPOSITTRANSACTION GROUP BY DTTSEQUENCE ) c ON CONVERT( VARCHAR(7), d.DTTTRANSACTIONDATE, 102) = CONVERT( VARCHAR(7), c.RecentTransDate, 102) AND c.DTTSEQUENCE = d.DTTSEQUENCE GROUP BY c.DTTSEQUENCE, d.DTTBRANCHCODE, d.DTTPRODUCTCODE, d.DTTCHECKDIGIT, RecentTransDate, noOfTransSymls )tthen see results like this:SELECT * FROM myView --Chandu |
|
|
dayna
Starting Member
14 Posts |
Posted - 2012-12-10 : 00:48:38
|
i created already the view and it works perfectly. i have no problem with that..but my question is that, is it possible to count the transaction without creating view.because i have already a table which is dmmdepositetransaction from that table itself i will count transaction monthly. from the above sample it will come up that i have two tables, im calling the dmmdeposittransaction to my view table and name it as table t.dcometa |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2012-12-10 : 01:29:30
|
>> is it possible to count the transaction without creating view?Yes no need of creating view. U can use my query directlySELECT MONTH(RecentTransDate) TranMonth, YEAR(RecentTransDate) TransYear, noOfTransSymls, noOfTrans, DTTPRODUCTCODE, DTTBRANCHCODE, DTTSEQUENCE, DTTCHECKDIGITFROM ( SELECT distinct noOfTransSymls, COUNT(*) noOfTrans, d.DTTBRANCHCODE, d.DTTPRODUCTCODE, c.DTTSEQUENCE, d.DTTCHECKDIGIT, RecentTransDate FROM DMMDEPOSITTRANSACTION d JOIN (SELECT DTTSEQUENCE, MAX(DTTTRANSACTIONDATE) RecentTransDate,COUNT( distinct DTTTRANSACTIONSYMBOL) noOfTransSymls FROM DMMDEPOSITTRANSACTION GROUP BY DTTSEQUENCE ) c ON CONVERT( VARCHAR(7), d.DTTTRANSACTIONDATE, 102) = CONVERT( VARCHAR(7), c.RecentTransDate, 102) AND c.DTTSEQUENCE = d.DTTSEQUENCE GROUP BY c.DTTSEQUENCE, d.DTTBRANCHCODE, d.DTTPRODUCTCODE, d.DTTCHECKDIGIT, RecentTransDate, noOfTransSymls )t1 --Chandu |
|
|
dayna
Starting Member
14 Posts |
Posted - 2012-12-10 : 02:21:48
|
i tried that query but their is no output.another thing, is it important to put t1? correct me if wrong is the t1 is the name of the table? what is the purpose of that?sorry for so much question, but im lost already..,dcometa |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2012-12-10 : 02:39:59
|
quote: Originally posted by dayna i tried that query but their is no output.another thing, is it important to put t1? correct me if wrong is the t1 is the name of the table? what is the purpose of that?sorry for so much question, but im lost already..,dcometa
t1 is alias name for that intermediate result set. You can give any name there...SELECT MONTH(RecentTransDate) TranMonth, YEAR(RecentTransDate) TransYear, noOfTransSymls, noOfTrans, DTTPRODUCTCODE, DTTBRANCHCODE, DTTSEQUENCE, DTTCHECKDIGITFROM ( SELECT distinct noOfTransSymls, COUNT(*) noOfTrans, d.DTTBRANCHCODE, d.DTTPRODUCTCODE, c.DTTSEQUENCE, d.DTTCHECKDIGIT, RecentTransDate FROM DMMDEPOSITTRANSACTION d JOIN (SELECT DTTSEQUENCE, MAX(DTTTRANSACTIONDATE) RecentTransDate,COUNT( distinct DTTTRANSACTIONSYMBOL) noOfTransSymls FROM DMMDEPOSITTRANSACTION GROUP BY DTTSEQUENCE ) c ON CONVERT( VARCHAR(7), d.DTTTRANSACTIONDATE, 102) = CONVERT( VARCHAR(7), c.RecentTransDate, 102) AND c.DTTSEQUENCE = d.DTTSEQUENCE GROUP BY c.DTTSEQUENCE, d.DTTBRANCHCODE, d.DTTPRODUCTCODE, d.DTTCHECKDIGIT, RecentTransDate, noOfTransSymls )t1 That red marked part is your table name..--Chandu |
|
|
dayna
Starting Member
14 Posts |
Posted - 2012-12-10 : 02:47:39
|
ok i got it, but i tried that query but no result..supposed to be transmonth, transyear,nooftranssymbls, and nooftrans appeared on the table dmmdeposittransaction but it seems no additional name in the table dmmdeposittransaction. how can i do it to appeared that on my table?dcometa |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2012-12-10 : 03:31:57
|
These are also the columns( DTTPRODUCTCODE, DTTBRANCHCODE, DTTSEQUENCE, DTTCHECKDIGIT) of your table.... right?--Chandu |
|
|
Next Page
|
|
|
|
|