Chelodina above larger ones. Palazzo Spada was purchased by the Italian State in 1927 and today houses the Italian Council of State, which meets in its richly frescoed and stuccoed rooms. Palazzo Spada The Palazzo Spada is a palace located on Piazza di Capo Ferro #13 in the rione Regola of Rome, Italy. Standing very close to the Palazzo Farnese, it has a garden facing towards the Tiber river. The palace accommodates a large art collection, the Galleria Spada. The collection was originally assembled by Cardinal Bernardino Spada in the 17th century, and by his brother Virgilio Spada, and added to 	Palazzo Spada
6448006	Yukon–Kuskokwim Delta Yukon–Kuskokwim Delta The Yukon–Kuskokwim Delta is a river delta located where the Yukon and Kuskokwim rivers empty into the Bering Sea on the west coast of the U.S. state of Alaska. At approximately in size, it is one of the largest deltas in the world. It is larger than the Mississippi River Delta (which varies between 32,400 and 122,000 square kilometers or 12,500 and 47,100 sq mi); it is comparable in size to the entire U.S. state of Louisiana (135,700 square kilometers or 52,400 sq mi). The delta, which consists mainly of tundra, is protected as part of 	Yukon–Kuskokwim Delta
6448007	the Yukon Delta National Wildlife Refuge. The delta has approximately 25,000 residents. 85% of these are Alaska Natives: Yupik and Athabaskan people. The main population center and service hub is the city of Bethel, with an estimated population of around 6,219 (as of 2011). Bethel is surrounded by 49 smaller villages, with the largest villages consisting of over 1000 people. Most residents live a traditional subsistence lifestyle of hunting, fishing, and gathering. More than 30 percent have cash incomes well below the federal poverty threshold. The area has virtually no roads; travel is by Bush plane, or riverboats in summer 	Yukon–Kuskokwim Delta
6448008	and snowmachines in winter. Bethel is the location of the Yukon Kuskokwim Correctional Center. Yukon–Kuskokwim Delta The Yukon–Kuskokwim Delta is a river delta located where the Yukon and Kuskokwim rivers empty into the Bering Sea on the west coast of the U.S. state of Alaska. At approximately in size, it is one of the largest deltas in the world. It is larger than the Mississippi River Delta (which varies between 32,400 and 122,000 square kilometers or 12,500 and 47,100 sq mi); it is comparable in size to the entire U.S. state of Louisiana (135,700 square kilometers or 52,400 	Yukon–Kuskokwim Delta
6448009	Set operations (SQL) Set operations (SQL) Set operations allow the results of multiple queries to be combined into a single result set. Set operators include codice_1, codice_2, and codice_3. UNION operator. In SQL the codice_1 clause combines the results of two SQL queries into a single table of all matching rows. The two queries must result in the same number of columns and compatible data types in order to unite. Any duplicate records are automatically removed unless codice_5 is used. codice_1 can be useful in data warehouse applications where tables aren't perfectly normalized. A simple example would be a database having tables 	Set operations (SQL)
6448010	codice_7 and codice_8 that have identical structures but are separated because of performance considerations. A codice_1 query could combine results from both tables. Note that codice_5 does not guarantee the order of rows. Rows from the second operand may appear before, after, or mixed with rows from the first operand. In situations where a specific order is desired, codice_11 must be used. Note that codice_5 may be much faster than plain codice_1. Examples. Given these two tables: Executing this statement: SELECT * FROM sales2005 UNION SELECT * FROM sales2006; yields this result set, though the order of the rows can vary because 	Set operations (SQL)
6448011	no codice_11 clause was supplied: Note that there are two rows for Joe because those rows are distinct across their columns. There is only one row for Alex because those rows are not distinct for both columns. codice_5 gives different results, because it will not eliminate duplicates. Executing this statement: SELECT * FROM sales2005 UNION ALL SELECT * FROM sales2006; would give these results, again allowing variance for the lack of an codice_11 statement: The discussion of full outer joins also has an example that uses codice_1. INTERSECT operator. The SQL codice_2 operator takes the results of two queries and returns only 	Set operations (SQL)
6448012	rows that appear in both result sets. For purposes of duplicate removal the codice_2 operator does not distinguish between codice_20. The codice_2 operator removes duplicate rows from the final result set. The codice_22 operator does not remove duplicate rows from the final result set, but if a row appears X times in the first query and Y times in the second, it will appear min(X, Y) times in the result set. Example. The following example codice_2 query returns all rows from the Orders table where Quantity is between 50 and 100. SELECT * FROM Orders WHERE Quantity BETWEEN 1 AND 100 	Set operations (SQL)
6448013	INTERSECT SELECT * FROM Orders WHERE Quantity BETWEEN 50 AND 200; EXCEPT operator. The SQL codice_3 operator takes the distinct rows of one query and returns the rows that do not appear in a second result set. For purposes of row elimination and duplicate removal, the codice_3 operator does not distinguish between codice_20. The codice_27 operator does not remove duplicates, but if a row appears X times in the first query and Y times in the second, it will appear max(X - Y, 0) times in the result set. Notably, the Oracle platform provides a codice_28 operator which is functionally equivalent to 	Set operations (SQL)
6448014	the codice_29 operator . Example. The following example codice_3 query returns all rows from the Orders table where Quantity is between 1 and 49, and those with a Quantity between 76 and 100. Worded another way; the query returns all rows where the Quantity is between 1 and 100, apart from rows where the quantity is between 50 and 75. SELECT * FROM Orders WHERE Quantity BETWEEN 1 AND 100 EXCEPT SELECT * FROM Orders WHERE Quantity BETWEEN 50 AND 75; Example. The following example is equivalent to the above example but without using the codice_3 operator. SELECT o1.* FROM ( LEFT JOIN ( ON 	Set operations (SQL)
6448015	o1.id = o2.id WHERE o2.id IS NULL Set operations (SQL) Set operations allow the results of multiple queries to be combined into a single result set. Set operators include codice_1, codice_2, and codice_3. UNION operator. In SQL the codice_1 clause combines the results of two SQL queries into a single table of all matching rows. The two queries must result in the same number of columns and compatible data types in order to unite. Any duplicate records are automatically removed unless codice_5 is used. codice_1 can be useful in data warehouse applications where tables aren't perfectly normalized. A simple 	Set operations (SQL)
6448016	Chelodina Chelodina Chelodina, collectively known as snake-necked turtles, is a large and diverse genus of long-necked chelid turtles with a complicated nomenclatural history. Although in the past, Macrochelodina" and "Macrodiremys" have been considered separate genera and prior to that all the same, they are now considered subgenera of the "Chelodina", further "Macrochelodina" and "Macrodiremys" are now known to apply to the same species, hence "Chelydera" is used for the northern snake-necked turtles. "Chelodina" is an ancient group of chelid turtles native to Australia, New Guinea, the Indonesian Rote Island, and East Timor. The turtles within this subgenus are  small to medium-sized with oval shaped carapace. They are side-necked turtles, meaning they tuck their head partially around the side of their body when threatened instead of directly backwards. "Chelydera" represents those species that have often been termed the "Chelodina" B group or thick necked snake neck turtles. The subgenus was described in 2020 by Thomson & Georges (in Shea et al. 2020). They are a side-neck turtle of the family Chelidae with extremely long necks and long flattened heads. They are specialist fish eaters using a strike and gape mode of feeding. They are medium to large  species with the largest "Chelodina (Chelydera) expansa" reaching shell lengths of some . The first fossils ("C. (Chelydera) alanrixi") are known from Queensland from the Eocene period (Lapparent de Broin, F. de, & Molnar, R. E., 2001). "Macrochelodina" (Wells & Wellington, 1985) is a monotypic subgenus of the "Chelodina". Its sole member is the enigmatic "Chelodina" ("Macrochelodina") "oblonga" from Western Australia. Taxonomy. Current taxonomy follows that of Georges & Thomson, 2010 with updates from van Dijk et al. 2014 and Shea et al. 2020. Synonymous names for the "Chelodina" genus include: "Hydraspis" , "Chelyodina" (nomen novum), "Hesperochelodina" (nomen nudum). The type species for the "Chelodina  subgenus is Chelodina longicollis" . The type species for the "Chelydera" subgenus is "Chelodina parkeri" . The type species for "Macrochelodina" is "Chelodina oblonga" . Extinct species. There are three identified extinct species of Chelodina: Chelodina Chelodina, collectively known as snake-necked turtles, is a large and diverse genus of long-necked chelid turtles with a complicated nomenclatural history. Although in the past, "Macrochelodina" and "Macrodiremys" have been considered separate genera and prior to that all the same, they are now considered subgenera of the "Chelodina", further "Macrochelodina" and "Macrodiremys" are now known to apply to the same species, hence "Chelydera" is used