| 1. |
info: 2025-04-26 02:19:47.716 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
2ms [Parameters=[@__id_0='40e3adc6-efee-45c2-5206-2746c20c0026', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [c].[Id], [c].[Active], [c].[Deleted], [c].[Description], [c].[DescriptionBackup], [c].[Left], [c].[ParentId], [c].[Position], [c].[ProcessorGenerateImagePrompt], [c].[Right], [c].[SiteId], [c].[StorageMediaName], [c].[StorageMediaUrl], [c].[Title], [c].[TitleBackup], [c].[TitleSlug], [c].[TotalChildren], [c].[TotalScanners], [c].[TotalYoutubeVideos]
FROM [Categories] AS [c] WITH (NOLOCK)
WHERE [c].[Id] = @__id_0 AND [c].[SiteId] = @__site_Id_1 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Id]
|
| 2. |
info: 2025-04-26 02:19:47.718 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
1ms [Parameters=[@__id_0='40e3adc6-efee-45c2-5206-2746c20c0026', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [c4].[Id], [c4].[Active], [c4].[Deleted], [c4].[Description], [c4].[DescriptionBackup], [c4].[Left], [c4].[ParentId], [c4].[Position], [c4].[ProcessorGenerateImagePrompt], [c4].[Right], [c4].[SiteId], [c4].[StorageMediaName], [c4].[StorageMediaUrl], [c4].[Title], [c4].[TitleBackup], [c4].[TitleSlug], [c4].[TotalChildren], [c4].[TotalScanners], [c4].[TotalYoutubeVideos], [c].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c0].[Id], [c0].[Active], [c0].[Deleted], [c0].[Description], [c0].[DescriptionBackup], [c0].[Left], [c0].[ParentId], [c0].[Position], [c0].[ProcessorGenerateImagePrompt], [c0].[Right], [c0].[SiteId], [c0].[StorageMediaName], [c0].[StorageMediaUrl], [c0].[Title], [c0].[TitleBackup], [c0].[TitleSlug], [c0].[TotalChildren], [c0].[TotalScanners], [c0].[TotalYoutubeVideos]
FROM [Categories] AS [c0] WITH (NOLOCK)
WHERE [c0].[Active] = CAST(1 AS bit) AND [c0].[Deleted] = CAST(0 AS bit)
) AS [c4] ON [c].[Id] = [c4].[ParentId]
WHERE [c].[Id] = @__id_0 AND [c].[SiteId] = @__site_Id_1 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Id], [c4].[Position], [c4].[Id]
|
| 3. |
info: 2025-04-26 02:19:47.719 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
1ms [Parameters=[@__id_0='40e3adc6-efee-45c2-5206-2746c20c0026', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [s5].[ScannerId], [s5].[CategoryId], [s5].[Id], [s5].[Active], [s5].[CheatSheet], [s5].[CheatSheet2], [s5].[Deleted], [s5].[FactErrors], [s5].[FactErrorsExplanation], [s5].[ParentCategory2Id], [s5].[ParentCategoryId], [s5].[ProcessorGenerateImagePrompt], [s5].[Prompt], [s5].[Reference], [s5].[ReferenceSlug], [s5].[SiteId], [s5].[SpellingErrors], [s5].[SpellingErrorsExplanation], [s5].[Summary], [s5].[Title], [s5].[TitleBackup], [s5].[TitleSlug], [s5].[TotalCards], [s5].[TotalCards2], [s5].[TotalCategories], [s5].[TotalPages], [s5].[Verified], [c].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [s1].[Id], [s1].[Active], [s1].[CheatSheet], [s1].[CheatSheet2], [s1].[Deleted], [s1].[FactErrors], [s1].[FactErrorsExplanation], [s1].[ParentCategory2Id], [s1].[ParentCategoryId], [s1].[ProcessorGenerateImagePrompt], [s1].[Prompt], [s1].[Reference], [s1].[ReferenceSlug], [s1].[SiteId], [s1].[SpellingErrors], [s1].[SpellingErrorsExplanation], [s1].[Summary], [s1].[Title], [s1].[TitleBackup], [s1].[TitleSlug], [s1].[TotalCards], [s1].[TotalCards2], [s1].[TotalCategories], [s1].[TotalPages], [s1].[Verified]
FROM [CategoryScanners] AS [c3]
INNER JOIN [Scanners] AS [s1] ON [c3].[ScannerId] = [s1].[Id]
WHERE [s1].[Active] = CAST(1 AS bit) AND [s1].[Deleted] = CAST(0 AS bit)
) AS [s5] ON [c].[Id] = [s5].[CategoryId]
WHERE [c].[Id] = @__id_0 AND [c].[SiteId] = @__site_Id_1 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Id], [s5].[Id], [s5].[ScannerId], [s5].[CategoryId]
|
| 4. |
info: 2025-04-26 02:19:47.729 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
9ms [Parameters=[@__id_0='40e3adc6-efee-45c2-5206-2746c20c0026', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [s6].[Id], [s6].[Active], [s6].[Context], [s6].[ContextBackup], [s6].[ContextStorageMediaName], [s6].[ContextStorageMediaUrl], [s6].[Deleted], [s6].[FactErrors], [s6].[FactErrorsExplanation], [s6].[Facts], [s6].[FactsBackup], [s6].[FactsStorageMediaName], [s6].[FactsStorageMediaUrl], [s6].[Position], [s6].[ProcessorGenerateImagePrompt], [s6].[Prompt], [s6].[ScannerId], [s6].[SpellingErrors], [s6].[SpellingErrorsExplanation], [s6].[StorageMediaName], [s6].[StorageMediaUrl], [s6].[Summary], [s6].[SummaryBackup], [s6].[SummaryStorageMediaName], [s6].[SummaryStorageMediaUrl], [s6].[Title], [s6].[TitleSlug], [s6].[TotalFillTheBlankSelectionQuestions], [s6].[TotalMultipleSelectionQuestions], [s6].[TotalOrderingQuestions], [s6].[TotalQuestionPoints], [s6].[TotalQuestions], [s6].[TotalShortAnswerQuestions], [s6].[TotalSingleSelectionQuestions], [s6].[TotalSources], [s6].[TotalTrueFalseQuestions], [s6].[Verified], [s6].[Version], [c].[Id], [s5].[ScannerId], [s5].[CategoryId], [s5].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [s1].[Id]
FROM [CategoryScanners] AS [c3]
INNER JOIN [Scanners] AS [s1] ON [c3].[ScannerId] = [s1].[Id]
WHERE [s1].[Active] = CAST(1 AS bit) AND [s1].[Deleted] = CAST(0 AS bit)
) AS [s5] ON [c].[Id] = [s5].[CategoryId]
INNER JOIN (
SELECT [s2].[Id], [s2].[Active], [s2].[Context], [s2].[ContextBackup], [s2].[ContextStorageMediaName], [s2].[ContextStorageMediaUrl], [s2].[Deleted], [s2].[FactErrors], [s2].[FactErrorsExplanation], [s2].[Facts], [s2].[FactsBackup], [s2].[FactsStorageMediaName], [s2].[FactsStorageMediaUrl], [s2].[Position], [s2].[ProcessorGenerateImagePrompt], [s2].[Prompt], [s2].[ScannerId], [s2].[SpellingErrors], [s2].[SpellingErrorsExplanation], [s2].[StorageMediaName], [s2].[StorageMediaUrl], [s2].[Summary], [s2].[SummaryBackup], [s2].[SummaryStorageMediaName], [s2].[SummaryStorageMediaUrl], [s2].[Title], [s2].[TitleSlug], [s2].[TotalFillTheBlankSelectionQuestions], [s2].[TotalMultipleSelectionQuestions], [s2].[TotalOrderingQuestions], [s2].[TotalQuestionPoints], [s2].[TotalQuestions], [s2].[TotalShortAnswerQuestions], [s2].[TotalSingleSelectionQuestions], [s2].[TotalSources], [s2].[TotalTrueFalseQuestions], [s2].[Verified], [s2].[Version]
FROM [ScannerCards] AS [s2]
WHERE [s2].[Active] = CAST(1 AS bit) AND [s2].[Deleted] = CAST(0 AS bit)
) AS [s6] ON [s5].[Id] = [s6].[ScannerId]
WHERE [c].[Id] = @__id_0 AND [c].[SiteId] = @__site_Id_1 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Id], [s5].[Id], [s5].[ScannerId], [s5].[CategoryId], [s6].[TitleSlug], [s6].[Id]
|
| 5. |
info: 2025-04-26 02:19:47.738 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
7ms [Parameters=[@__id_0='40e3adc6-efee-45c2-5206-2746c20c0026', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [q0].[Id], [q0].[Active], [q0].[Created], [q0].[Deleted], [q0].[Points], [q0].[ProcessorGenerateImagePrompt], [q0].[ScannerCardId], [q0].[StorageMediaName], [q0].[StorageMediaUrl], [q0].[Title], [q0].[TotalAnswers], [q0].[Type], [c].[Id], [s5].[ScannerId], [s5].[CategoryId], [s5].[Id], [s6].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [s1].[Id]
FROM [CategoryScanners] AS [c3]
INNER JOIN [Scanners] AS [s1] ON [c3].[ScannerId] = [s1].[Id]
WHERE [s1].[Active] = CAST(1 AS bit) AND [s1].[Deleted] = CAST(0 AS bit)
) AS [s5] ON [c].[Id] = [s5].[CategoryId]
INNER JOIN (
SELECT [s2].[Id], [s2].[ScannerId], [s2].[TitleSlug]
FROM [ScannerCards] AS [s2]
WHERE [s2].[Active] = CAST(1 AS bit) AND [s2].[Deleted] = CAST(0 AS bit)
) AS [s6] ON [s5].[Id] = [s6].[ScannerId]
INNER JOIN (
SELECT [q].[Id], [q].[Active], [q].[Created], [q].[Deleted], [q].[Points], [q].[ProcessorGenerateImagePrompt], [q].[ScannerCardId], [q].[StorageMediaName], [q].[StorageMediaUrl], [q].[Title], [q].[TotalAnswers], [q].[Type]
FROM [Questions] AS [q]
WHERE [q].[Active] = CAST(1 AS bit) AND [q].[Deleted] = CAST(0 AS bit)
) AS [q0] ON [s6].[Id] = [q0].[ScannerCardId]
WHERE [c].[Id] = @__id_0 AND [c].[SiteId] = @__site_Id_1 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Id], [s5].[Id], [s5].[ScannerId], [s5].[CategoryId], [s6].[TitleSlug], [s6].[Id], [q0].[Id]
|
| 6. |
info: 2025-04-26 02:19:47.746 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
7ms [Parameters=[@__id_0='40e3adc6-efee-45c2-5206-2746c20c0026', @__site_Id_1='63d6eb4e-8e39-4ac6-8f69-55ee76feccce'], CommandType='Text', CommandTimeout='30']
SELECT [s7].[TagId], [s7].[ScannerCardId], [s7].[Id], [s7].[Active], [s7].[Created], [s7].[Deleted], [s7].[Description], [s7].[Links], [s7].[MediaSourceCopyright], [s7].[MediaSourceUrl], [s7].[ShortDescription], [s7].[SiteId], [s7].[StorageMediaName], [s7].[StorageMediaUrl], [s7].[Title], [s7].[TitleSlug], [s7].[Url], [s7].[Wikipedia], [s7].[WikipediaPageId], [s7].[WikipediaUpdated], [c].[Id], [s5].[ScannerId], [s5].[CategoryId], [s5].[Id], [s6].[Id]
FROM [Categories] AS [c] WITH (NOLOCK)
INNER JOIN (
SELECT [c3].[ScannerId], [c3].[CategoryId], [s1].[Id]
FROM [CategoryScanners] AS [c3]
INNER JOIN [Scanners] AS [s1] ON [c3].[ScannerId] = [s1].[Id]
WHERE [s1].[Active] = CAST(1 AS bit) AND [s1].[Deleted] = CAST(0 AS bit)
) AS [s5] ON [c].[Id] = [s5].[CategoryId]
INNER JOIN (
SELECT [s2].[Id], [s2].[ScannerId], [s2].[TitleSlug]
FROM [ScannerCards] AS [s2]
WHERE [s2].[Active] = CAST(1 AS bit) AND [s2].[Deleted] = CAST(0 AS bit)
) AS [s6] ON [s5].[Id] = [s6].[ScannerId]
INNER JOIN (
SELECT [t].[TagId], [t].[ScannerCardId], [t0].[Id], [t0].[Active], [t0].[Created], [t0].[Deleted], [t0].[Description], [t0].[Links], [t0].[MediaSourceCopyright], [t0].[MediaSourceUrl], [t0].[ShortDescription], [t0].[SiteId], [t0].[StorageMediaName], [t0].[StorageMediaUrl], [t0].[Title], [t0].[TitleSlug], [t0].[Url], [t0].[Wikipedia], [t0].[WikipediaPageId], [t0].[WikipediaUpdated]
FROM [TagScannerCards] AS [t]
INNER JOIN [Tags] AS [t0] ON [t].[TagId] = [t0].[Id]
WHERE [t0].[Active] = CAST(1 AS bit) AND [t0].[Deleted] = CAST(0 AS bit)
) AS [s7] ON [s6].[Id] = [s7].[ScannerCardId]
WHERE [c].[Id] = @__id_0 AND [c].[SiteId] = @__site_Id_1 AND [c].[Active] = CAST(1 AS bit) AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Id], [s5].[Id], [s5].[ScannerId], [s5].[CategoryId], [s6].[TitleSlug], [s6].[Id], [s7].[TitleSlug]
|
| 7. |
info: 2025-04-26 02:19:47.814 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
7ms [Parameters=[@p7='72090e40-17eb-4f9a-8764-bd48ef9870bf', @p0='True', @p1='False', @p2='1', @p3='66077d8c-8eba-480f-aab5-5dd3188e8b14', @p4='77.jpg' (Size = 100), @p5='https://knowledgenest.blob.core.windows.net/scanners/0/[Matematika][Matematika visiems 6 klasė][Vadovėlis 2 dalis]/pages/77.jpg' (Size = 1000), @p6='""
# Uždaviniai
**u223** Milda apklausė klasės draugus, kiek naminių gyvūnų jie augina.
Duomenis ji suregistravo lentelėje. Šiuos duomenis pateikite dažnių lentele.
| Gyvūnų skaičius | 0 | 1 | 2 | 3 | 4 ir daugiau |
|---|---|---|---|---|---|
| Registravimas | 2 | 12 | 6 | 4 | 1 |
**u224** Dažnių lentele pateikti vienos mokyklos visų šeštų klasių mokinių matematikos kontrolinio darbo rezultatai. Kiek šeštokų rašė kontrolinį darbą?
A 44 B 43 C 42 D 41
| Pažymys | 4 | 6 | 7 | 8 | 9 | 10 |
|---|---|---|---|---|---|---|
| Dažnis | 2 | 7 | 11 | 9 | 7 | 5 |
**u225** Apklausus 377 pirkėjus, kokius ledus jie labiausiai mėgsta, surinkti duomenys buvo pateikti dažnių lentele. Kiekvienas pirkėjas galėjo pasirinkti tik vienos iš nurodytų rūšių ledus. Remdamiesi lentele, apskaičiuokite, kiek apklaustųjų pasirinko vaisinius ledus.
| Ledų rūšis | Šokoladiniai | Vaniliniai | Vaisiniai |
|---|---|---|---|
| Dažnis | 78 | 243 | ? |
**u226** Apklausus vienos klasės mokinius, kiek vaikų auga jų šeimose, gauti tokie duomenys:
1, 2, 3, 3, 2, 2, 2, 1, 4, 2, 6, 2, 3, 4, 2, 2, 1, 1, 3, 3, 1, 2, 1, 3.
Šiuos duomenis pateikite dažnių lentele.
**u227** Mokyklos gimtadieniui visiems jos mokiniams buvo užsakomi vienodi marškinėliai. Klasių auklėtojai surinko duomenis apie mokinių drabužių dydžius, kurie pateikti dažnių lentele:
| Marškinėlių dydis | XS | S | M | L | XL |
|---|---|---|---|---|---|
| Mokinių skaičius | 48 | 75 | 189 | 92 | 64 |
Remdamiesi ja:
a) nustatykite, kurio dydžio marškinėlių reikės užsakyti daugiausia ir kurio mažiausiai;
b) apskaičiuokite, kiek mokykloje mokosi mokinių.
**u228** Meteorologijos stotis pateikė viso mėnesio vėjo krypties ataskaitą:
| Vėjo kryptis | Š | ŠR | ŠV | P | PR | PV | R | V |
|---|---|---|---|---|---|---|---|---|
| Dažnis | 2 | 8 | 6 | 0 | 2 | 1 | 5 | 4 |
Remdamiesi dažnių lentele, nustatykite:
a) kuri vėjo kryptis tą mėnesį buvo dominuojanti;
b) kurio mėnesio ataskaitą pateikė meteorologijos stotis.
**u229** Žvejybos varžybose buvo sugauta 100 kuojų, ešerių – dvigubai mažiau negu kuojų, raudžių – 30% mažiau negu ešerių, karšių – 20% daugiau negu ešerių, o karosų – ⅔ karšių kiekio.
1) Sudarykite žvejybos varžybose sugautų žuvų dažnių lentelę.
2) Naudodamiesi ja, apskaičiuokite, kiek iš viso žuvų buvo sugauta žvejybos varžybose.
**u230** Žaidimo metu kiekvienas mokinys pasirinko vieną vienaženklį pirminį skaičių.
Mažiausią pirminį skaičių pasirinko 8 mokiniai, pirminį skaičiaus 49 daliklį pasirinko 5 mokiniai, o pirminį daliklį visų skaičių, kurių paskutinis skaitmuo yra 5, pasirinko 11 mokinių.
1) Sudarykite šių duomenų dažnių lentelę.
2) Ar tiesa, kad mažiausią pirminį skaičių pasirinko 25% mokinių?
""' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SET IMPLICIT_TRANSACTIONS OFF;
SET NOCOUNT ON;
UPDATE [ScannerPages] SET [Active] = @p0, [Deleted] = @p1, [Position] = @p2, [ScannerId] = @p3, [StorageMediaName] = @p4, [StorageMediaUrl] = @p5, [Text] = @p6
OUTPUT 1
WHERE [Id] = @p7;
|
| 8. |
info: 2025-04-26 02:19:47.862 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
9ms [Parameters=[@__site_Id_0='63d6eb4e-8e39-4ac6-8f69-55ee76feccce', @__item_Left_1='14042', @__item_Right_2='14043'], CommandType='Text', CommandTimeout='30']
SELECT [c].[Id], [c].[Active], [c].[Deleted], [c].[Description], [c].[DescriptionBackup], [c].[Left], [c].[ParentId], [c].[Position], [c].[ProcessorGenerateImagePrompt], [c].[Right], [c].[SiteId], [c].[StorageMediaName], [c].[StorageMediaUrl], [c].[Title], [c].[TitleBackup], [c].[TitleSlug], [c].[TotalChildren], [c].[TotalScanners], [c].[TotalYoutubeVideos]
FROM [Categories] AS [c] WITH (NOLOCK)
WHERE [c].[SiteId] = @__site_Id_0 AND [c].[Left] <= @__item_Left_1 AND [c].[Right] >= @__item_Right_2 AND [c].[Deleted] = CAST(0 AS bit)
ORDER BY [c].[Left]
|
| 43 ms |
